I have a program that does that in the online AFL library, The name of the afl program is Export EOD by Barry Scarborough. It will export EOD and intraday data to a csv file and it will create multiple files with an suffix A, B,,,D if necessary. This is because Excel will only hold 65,000 lines. If you go over that the data is truncated, lost. This is not a problem with daily data but it is easy to have more than 100,000 lines of one minute or tick data. This program will export 321,000 lines.
The exported fields are "Ticker,Date,Open,High,Low,Close,Volume" or
"Ticker,Date,Time,Open,High,Low,Close,Volume" for intraday.
If you use this you my need to change the target drive. It puts data in D:\AmiBackup. You can change the code on line 22 if you want to put it somewhere else.
Barry
__._,_.___
Posted by: razzbarry@imageview.us
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Upgrade your account with the latest Yahoo Mail app
Get organized with the fast and easy-to-use Yahoo Mail app. Upgrade today!
**** IMPORTANT PLEASE READ ****
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/
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