I use this method to download historical stock prices from yahoo finance. It works fast and well. Faster than AmiQuote.
I do the download into an ASCII CSV string variable, before using the excel VBA split() function to 1st parse each date line into a VBA string array containing CSV for all dates, and then 2nd parse each date into a "date, open, high, low, close, volume, adj. close" VBA string array that is then inserted into a spread sheet or Access DB.
The only problem I ever have is a corrupted csv download file.
If you will provide more details on what you are doing, perhaps I can help.
From: amibroker@yahoogroups.com [mailto:amibroker@yahoogroups.com]
Sent: Sunday, February 14, 2016 8:30 PM
To: amibroker@yahoogroups.com
Subject: [amibroker] VBA excel what am i doing wrong
ss = Split(Text, ",")
numberofquotes = Amibroker.Stocks("bby").Quotations.Count
numberofquotes = Amibroker.Stocks(ss(0)).Quotations.Count
Posted by: "Jim Gunn" <jimgunn@jgunnresearch.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
This group is for the discussion between users only.
This is *NOT* technical support channel.
TO GET TECHNICAL SUPPORT send an e-mail directly to
SUPPORT {at} amibroker.com
TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)
For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/
EmoticonEmoticon