YHOO_Price is not correct

Discussion in 'Troubleshooting' started by MikeH, Apr 2, 2016.

YHOO_Price is not correct

  1. MikeH

    MikeH New Member

    Joined:
    Mar 29, 2016
    Messages:
    11
    Likes Received:
    0
    Ankur,

    YHOO_Price is not correct.  I priced AAPL  =YHOO_Price(""AAPL") at 4:30pm EST and got 109.59.  I checked the  Fidelity and Yahoo websites and both had Apple at 109.99.  At 5:40pm EST I repriced AAPL with YHOO_Price and this time I got 109.71

    Regards,

    Mike
     
  2. MikeH

    MikeH New Member

    Joined:
    Mar 29, 2016
    Messages:
    11
    Likes Received:
    0
    Just did a test and got the following results at 6:00pm EST

    Yahoo_price   last        last1        last2
    109.71               109.71  109.91     109.99

    Both Fidelity and Yahoo had the price at 109.99

    What is difference between last, last1 and last2 and what service are they getting their prices from?
     
  3. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10
    Hi Micheal,

    Thanks. Last, Last1, and Last 2 are basically all delayed pricing data. Just to make sure you do get values the idea to have these in a series of 1, 2, 3 so on in order of preference and optimization. So, ideally Last should be tried 1st, if it does not work then last 1 and so on.

    The data is delayed so there could be little differences, however, in this release we have a new function called =LastPriceRealTime("GOOG"), this should give you absolute real time pricing. Let me know if this one solves it?

     

    Thanks

    Ankur
     
  4. MikeH

    MikeH New Member

    Joined:
    Mar 29, 2016
    Messages:
    11
    Likes Received:
    0
    Ankur,

    The LastPriceRealTime function works.  I tested it against Fidelity and it is real time.  I do have a few problems getting some preferred stock prices, but for the few that aren't working I just use YHOO_Price.

    Thanks for your help,

    Mike

     
     
  5. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10
    Hi Micheal,

    YHOO_Price is going to be deprecated in coming releases, so In order to get the last functions working for preferred stocks,  please can you give me the preferred stocks which did not work with last function?

    Many Thanks

    Ankur
     
  6. MikeH

    MikeH New Member

    Joined:
    Mar 29, 2016
    Messages:
    11
    Likes Received:
    0
    Not all are preferreds:

    LINDW,JMPB,PBB,SBNA,RFTA,SSWN,SLTB,LMT,ARU,MSCA,COWNL

     
     

Share This Page