fetching market close data for 6669.TW I have discrepancies using TR.Volume in Excel Eikon API and C

MarkJoseph.Canada
MarkJoseph.Canada
in Eikon Data APIs

while fetching market close data for 6669.TW I have discrepancies using TR.Volume in Excel Eikon API and C Sharp Eikon API. I fetched data with Csharp 30 minutes later and Volume increased, is it possible that I am using the wrong formula for previous day market close?

Tagged:

Best Answer

  • nick.zincone
    nick.zincone
    Answer ✓

    Hi @d.fecher

    While monitors on this forum can help with the API, I think the best route to resolve details around the data would be to reach out to the helpdesk by either using the "Help & Support" within the desktop (Eikon/Refinitiv Workspace) or to use the Get Support service.

Answers

  • Jirapongse
    Jirapongse admin

    @MarkJoseph.Canada

    If you are using EikonDataAPI.NET. It may relate to this issue.

    The data in the DataFrame can be rounded because it uses System.Single to store the value.

    To verify the data, you can use the GetDataRaw method to get the raw content.

  • MarkJoseph.Canada
    MarkJoseph.Canada

    Hi please see response of our client


    It is not rounding issue, we are already using GetDataRaw function.
    Problem Is that Volumes are different as an example below:

    image

    “Volume” in the table above is fetched by Excel Eikon and “TVolume” is fetched 30 mins later via API, both using same formula “TR.Volume”.

    We need a market close data as of exact date, it looks like formula TR.Volume is fetching actual real time Volume. Could you elaborate please?

  • Jirapongse
    Jirapongse admin

    @MarkJoseph.Canada

    If the raw data is not rounded and it is the same as the data in the Dataframe, it could be a content issue.

    The following is the definition of the TR.Volume field.

    1655975917413.png

    You may need to contact the content team to verify the data of 6666.TW at different times.

  • d.fecher
    d.fecher

    Thanks for your response. The problem appears to be not in the Excel Eikon API or C Sharp Eikon API (GetDataRaw function is used) functions, but in the way the field is called.

    Apparently, calling only

    =TR(6669.TW,"TR.Volume")

    is not enough, because then the Date is unknown. The solution would be to call:

    =TR(6669.TW,"TR.Volume,TR.Volume.Date")

    And then check if the TR.Volume.Date is up-to-date or the value for today is not there yet.

    But in this case we know that this field is updated per day. However, what if the field has different update frequency? For instance, TR.FreeFloatPct is updated once per month.

    Thus, the question is: is there any way to call the frequency for the field?

    Something like,

    =TR(6669.TW,"TR.Volume,TR.Volume.Date,TR.Volume.Frequency")
    =TR(6669.TW,"TR.FreeFloatPct,TR.FreeFloatPct.Date, TR.FreeFloatPct.Frequency")

    would be good (this does not exist, but maybe there is something similar). Also, is there any way to find out which other stats for a field are available (for example: TR.Volume.OtherStat)?


    P.S: Calling the history with

    =TR(6669.TW,"TR.Volume, TR.Volume.Date", "SDate=1D EDate=-7AY RH=IN")

    will be the most complicated solution in order to find the frequency.


  • d.fecher
    d.fecher
    Sure, thanks!

Categories