Getting Market Holidays with Excel Eikon.

Best Answer

  • SupDev1
    SupDev1
    Answer ✓

    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.


Answers

  • aquilesjlp300
    aquilesjlp300

    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.

    image

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


    Thanks in advance for your help.

  • SupDev1
    SupDev1

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

  • Wan Po.Lee
    Wan Po.Lee

    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
    SupDev1

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


  • Wan Po.Lee
    Wan Po.Lee

    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?

  • SupDev1
    SupDev1

    Try "=AdStyleAttribute("CUR","JPY","CLDR")"

    You can retrieves the latest historical value available in the database for an index history style using "=AdHistoryValue(IndexName, StyleMode)"

    Or creates a style in a style table using "=AdStyleSet(StyleTable, StyleCode, StyleName, StyleStructure, StyleMode)"


  • Wan Po.Lee
    Wan Po.Lee

    Thank you again! I got it now. So we use the currency code to get the "market code" for this holiday table function.

Categories