how to get historical from data from yahoo finance Japan link from a particular Start Date to End date using VBA.

[abhi221996]

How can I get the historical data from the link below using VBA from the particular Start Date to end Date using VBA.
and is it possible to get multiple quotes using multiple tickers from Yahoo finance Japan.

トヨタ自動車(株)【7203】：株価時系列・信用残時系列 - Yahoo!ファイナンス

トヨタ自動車(株)【7203】の株価時系列や信用残時系列の推移をご覧いただけます。Yahoo!ファイナンスでは株価速報、チャート、ランキング、ポートフォリオ、ニュース、掲示板など投資判断に役立つ情報を掲載しています。

finance.yahoo.co.jp

 

[abhi221996]

Still looking for the solution if anybody can give any suggestions?

 

[tonyyy]

InvestExcel has a "multiple stock quote downloader" that works with yahoo finance usa. You might be able to adapt it for yahoo finance japan.

Cheers,

Tony

 

[Peter_SSs]

Duplicate to: How can I pull data or scrap table for multiple pages from the given link below for a particular start date to end date using VBA or power query?

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, since the other one has more responses, I have closed this thread so please continue in the linked thread.