I am trying to replace my GOOGLE Stock History Data (API) download code, with one from "BarCharts.com's" (API), and have the data downloaded into the same fields in my worksheet. The fields are as follows: Date, Open, High, Low, Close, Volume, into columns A - F of my "BackTest" work sheet. The download can contain between 1 an 5 years of data, depending on my request. The current GOOGLE download works, but the data at times has blank fields. This is totally beyond my abilities.
Any assistance will GREATLY be appreciated
Don
----------------------------------------------------
Here is a BarCharts.com URL/API request:
The extract returns the data in the following record format, which is received in a new browser window (html).
----------------------------------------------------------------------
Here is the existing Excel Macro I use to download the data from GOOGLE. The data is imported into a worksheet "BackData" columns A - F.
GOOGLE DATA automatically entered the data into my "BackTest" worksheet, Columns A, B, C, D, E, F
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks