Forum Discussion

Lorenzo's avatar
Lorenzo
Silver Contributor
Jul 12, 2022

Hi Eric9919 

 

If this can help & assuming you run a Windows version of Excel. Attached is a Power Query based "solution" that downloads history from Yahoo Finance. Put this together a year a ago for this thread (the OP was smart enough not to provide any feedback...) and enhanced it in the meantime

 

Just checked ==> still work 🙂

  • Eric9919's avatar
    Eric9919
    Copper Contributor
    Jul 13, 2022
    Thanks. It is working for Stock Tickers, but I am actually looking for market indices.
    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      Jul 13, 2022

      Eric9919 

      Re. It is working for Stock Tickers, but I am actually looking for market indices

      Not sure I understand but this might be due to my ignorance in investment terms

       

      Below is what STOCKHISTORY's function downloads for the NASDAQ Composite Index + on the right  what the query downloads from Yahoo finance for symbol ^IXIC. (symbol from page World Indices). With the exception of the [Volume]* not sure I see where the difference is:

       

       

      * Checked a couple other websites but they don't provide volume information

      ==> No idea which of the above ones is right

       

      Attached file contains a few index/indices, inc. HKSE (Hang Seng Index) but this might not be what you expect...

       

       

       

      • Eric9919's avatar
        Eric9919
        Copper Contributor
        Jul 13, 2022

        Lorenzo Thanks and you understood correctly.

         

        I was able to use STOCKHISTORY to download only NASDAQ history, but not the others.

        And thanks for your sample XLSX and I will try it for sure.

         

        Cheers,

         

        Eric

         

Resources