Getting Market Holidays with Excel Eikon.

Question

Question by aquilesjlp300 · Jan 11, 2020 at 04:42 AM · exchange holidays market holidays

Getting Market Holidays with Excel Eikon.

Hi,

How can I get Market Holidays using Eikon for Excel?

0

10 |1500 characters needed characters left characters exceeded

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

Answer 1 · 2020-01-11T20:20:08Z

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.

3 Show 7 · Share

10 |1500 characters needed characters left characters exceeded

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

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)

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.

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?

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")

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?

Getting Market Holidays with Excel Eikon.

1 Reply

Watch this question

Related Questions