why google finance doesn't adjust for LSE shares

Discussion in 'Data Sets and Feeds' started by blueraincap, Jun 30, 2020.

  1. Google finance has a historical (TTM) dividend yield number, which is more or less ok for most stocks.

    Say for HSBC (0005 HK, HSBA LN, HSBC US)
    https://www.google.com/search?tbm=fin&sxsrf=ALeKk01vzHfPnWhbbBnkCpadVwFJIy912w:1593529520435&ei=sFT7Xs-UGqiwmAWxsa-IBQ&stick=H4sIAAAAAAAAAONgecRoyi3w8sc9YSmdSWtOXmNU4-IKzsgvd80rySypFJLgYoOy-KR4uLj0c_UNjCpyzCuyeABlsi76OgAAAA&q=HKG:+0005&oq=0005&gs_l=finance-immersive.1.0.81l3.15595.16000.0.16874.4.4.0.0.0.0.97.358.4.4.0....0...1c.1.64.finance-immersive..0.4.356....0.6DOlRu4kdDQ#scso=_wlT7XpGnFIHemAXn64mYCg1:0

    Based-on pre-covid annualised dividends, it is about 10% yield.
    5.HK number fine, HSBC.US number fine, HSBA.LN is short by a factor of 100.
    HSBC pays out historically us$0.5/share,
    For 5.HK, 0.5*7.8 / 36 = 10% yield. #7.8 is USDHKD
    For HSBC.US, 0.5 / (23.3/5) = 10% yield #the 5 is ADR-to-ordinary share ratio
    For HSBA.LN, it should be 0.5/(380/100*1.25) = 10% yield #1.25GBPUSD, 100 is the LSE lot.

    I don't trade LSE but I think its share price is for 100 lot rather than per price (right?), so HSBA.LN quote of 380GBP should be 380/100 * 1.25 = 4.75US$ per share. Google Finance seems to miss that 100lot factor but adjusts for FX conversion. How can Mother Godness Google miss that. I see all LSE stocks having the same issue.
     
  2. jharmon

    jharmon

    You get what you pay for.
     
    TimtheEnchanter likes this.
  3. A decent broker like TDAmeritrade would have information on your investments that is far more accurate than yahoo finance or google. Get a better broker!
     
  4. as usual, useless comments follow