Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

avatar image
Question by aquilesjlp300 · Jan 11, 2020 at 04:42 AM · eikoneikon-data-apiworkspacepythonworkspace-data-apirefinitiv-dataplatform-eikonmarket-holidaysexchange-holidays

Getting Market Holidays with Excel Eikon.

Hi,

How can I get Market Holidays using Eikon for Excel?

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Reply

  • Sort: 
avatar image
Best Answer
Answer by SupDev1 · Jan 11, 2020 at 08:20 PM

Try DfListHolidays, example: =DfListHolidays("USA","2019","2020")

Name is usually the same as the ISO code, but there is many other calendar styles. Full list of available styles you can find on: TR-> Utilities->Admin Settings->Style Management->Calendar styles.


Comment
aquilesjlp300
veerapath.rungruengrayubkul
umer.nalla

People who like this

3 Show 7 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
aquilesjlp300 · Jan 11, 2020 at 09:49 PM 0
Share

It appear it has worked for others, as suggested in this post, In fact, I tried your suggestion and the example proposed in the post as well, but no luck.

What could be the issue? Is there some feature I have to turn on before doing this?


Thanks in advance for your help.

1578779293806.png (62.1 KiB)
avatar image
SupDev1 aquilesjlp300 · Jan 11, 2020 at 11:05 PM 0
Share

In A5 you use US, should be USA(or USM). In B7 try to cancel {, } and space.

avatar image
REFINITIV
Wan Po.Lee · Jan 14, 2020 at 08:44 AM 0
Share

What standard is applied to the country code? It is not the ISO-alpha3 code because this function is using "JAP" for Japan not the ISO "JPN". Where I can get the full list of country code that can be used in this function?

avatar image
SupDev1 Wan Po.Lee · Jan 14, 2020 at 09:23 AM 0
Share

You are right. To find code try to use "=AdStyleAttribute(StyleTable, StyleCode, StyleAttribute)", where: StyleTable - String argument defining the style table; StyleCode - Style code; StyleAttribute - Keyword corresponding to the style attribute

example:=AdStyleAttribute("CUR","JPN","CLDR")


avatar image
REFINITIV
Wan Po.Lee SupDev1 · Jan 14, 2020 at 09:56 AM 0
Share

Thank you! But when I try your example in Excel, I always get the "ERROR 3050 - StyleCode : invalid value.". I tried many codes like "JPN", "JAP", "JP", "JAPAN",...etc. Did I missed something?

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
12 People are following this question.

Related Questions

How to get market holidays in Python API

Retrieve Commodity Flows data using Python API

Trying to fetch Close Bid Price for CMO tranche from Python

Economic Monitor app from Eikon: How to get holidays for a single country.

Download API Proxy Python for Windows.

  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Intelligent Tagging
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open Calais
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • RDMS
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • Workspace SDK
    • Element Framework
    • Grid
  • World-Check Data File
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges