Need help importing Index Prices

Question

I need help automatically importing historical prices of index prices to Excel. I tried using the =STOCKHISTORY function but its not working for the Indonesian Market that I'm researching.

I tried this but doesn't work. I need the IHSG (JKSE), LQ45, JII, etc. The ticker is correct (rechecked it in Indonesia's stock exchange directory: IDX)

=STOCKHISTORY("XIDX: IHSG", [START DATE], [END DATE], 0,1,2]

I tried SPY and worked. Is there any workaround for this problem?

Answer 1

Hi @gchandra

IHSG (JKSE), LQ45, JII seems to be stock market indexes, STOCKHISTORY function does not support it, it needs a ticker symbol.

For more, please refer to: STOCKHISTORY function.

Here is a similar thread that import Index price into Excel: https://techcommunity.microsoft.com/t5/excel/does-stockhistory-work-for-indices-where-can-i-find-the-symbols/m-p/3570707

Lorenzo recommends using Excel Power Query to import data from a 3rd-party website.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---