Variable Sources

Discussion in 'Portfolio Management' started by James Grant, Dec 1, 2018.

Variable Sources

Tags:
  1. James Grant

    James Grant New Member

    Joined:
    Dec 21, 2017
    Messages:
    6
    Likes Received:
    1
    The source for MarketXLS variables apparently comes from Yahoo, but I am finding wide disagreement between what MarketXLS returns and what Yahoo provides. For example,

    =EPSEstimateNextYear (2019) for CELG gives a value of $9.29. At Yahoo Finance the amount is $10.35. That is a huge difference that dramatically effects a stock's valuation. Similarly, =EPSEstimateNextQuarter results in $2.01 but is $2.40 at Yahoo Finance, another huge difference.

    Can anyone explain this? Thanks.
     

Share This Page