Visokio website     Downloads     Video tutorials     KnowledgeBase  
Merging feed: Yahoo financial: Last trade day correct? - Visokio Forums
Merging feed: Yahoo financial: Last trade day correct?
  •     naruemon September 6, 2012 11:21PM
    When use 'Yahoo financial data' as input to retrieve the FX rate, the date in field 'Last trade date' is shifted 1 day ahead.
    Ex: Today is 6th Sep 2012 but the date in 'Last trade date' will be 7th Sep 2012.

    From the data, date will be shifted when it is 8:00 pm. Please find the attached files.
  • 7 Comments
  •     naruemon September 6, 2012 11:25PM
    The same problem occur on both v2.7 and v2.8
    v2.7 build 371
    v2.8 build 264
  •     chris September 7, 2012 5:03AM
    Hi,

    Thanks for reporting this to us. This is very confusing, and I'm not entirely sure why this is happening. We are trying to reproduce this issue (by manually changing our timezone). We'll let you know once we have any updates.
  •     chris September 7, 2012 5:07AM
    Hi,

    When this issue next occurs could you paste the following into your browser:

    http://finance.yahoo.com/d/quotes.csv?S=EURUSD%3DX&f=snd1t1l1yr

    This will download the equivalent data as a CSV file. Could you then check whether the data here is correct.
  •     naruemon September 11, 2012 11:07PM
    Hello Chris,

    Sorry for delay update.
    I noticed that the date will be shifted (to next day) when it is after 7am (BKK time: GMT+7).
    Ex: Bkk time - 12 Sep 2012 10:02 AM
    - Yahoo website: 11 Sep 2012 11:02 PM
    - Yahoo quotes (from your link): 12 Sep 2012 11:02 pm

    I captured the screenshot from yahoo website and Omniscope file here.
    Please find the attached files.

  •     chris September 12, 2012 5:30AM
    Hi,

    Is the CSV data shifted too or is it only in Omniscope?
  •     naruemon September 12, 2012 11:44AM
    Yes, the data in csv is shifted too.
  •     chris September 12, 2012 11:52AM
    Hi,

    Ok so it appears that yahoo is automatically shifting the date, but not the time, based on your location. It is slightly strange that they are not shifting the time as well, since this gives an incorrect value.

    We will investigate this further, but in the meantime you could compensate for this discrepancy adding a new formula field which would change the date back to the correct value.

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership