|
PureBytes Links
Trading Reference Links
|
There is a plugin available for exporting eod data to csv
files for each stock at one time.
Called Export in a zip file by Bruce Hearder. I thought it
was in yahoo Amibroker group files.
Alternatively try this
/*
Export EOD data to CSV files
One file for each stock
In the first line insert the directory you want to save them
to, make sure the directory exists
Select your charts to export with the "Apply to"
filter in AA window
Select the timeframe period you want to save as using the AA
"Settings"
Press Scan button
by Graham Kavanagh 05 Feb 2004
*/
fh = fopen( "c:\\SaveData\\"+Name()+".csv",
"w");
if( fh )
{
fputs( "Ticker,Date,Time,Open,High,Low,Close,Volume
\n", fh );
y = Year();
m = Month();
d = Day();
for( i = 0; i < BarCount; i++ )
{
fputs( Name() + ","
, fh );
ds = StrFormat("%04.0f-%02.0f-%02.0f,",
y[ i ], m[ i ], d[ i ] );
fputs( ds, fh );
qs = StrFormat("%.3f,%.3f,%.3f,%.3f,%.0f\n",
O[ i ],H[ i ],L[ i ],C[ i ],V[ i ] );
fputs( qs, fh );
}
fclose( fh );
}
Buy = 1;
Cheers,
Graham
http://e-wire.net.au/~eb_kavan/
<span
>-----Original Message-----
From: ronbo
[mailto:ronbo@xxxxxxxxxxxxxx]
Sent: Thursday, April 01, 2004
9:24 AM
To: amibroker@xxxxxxxxxxxxxxx
Subject: RE: [amibroker] Re: OT:
Does anyone use PFScan? if so, how do you download data?
<font size=2
face="Times New Roman">
<font size=2 color=blue
face=Arial>Jayson,
but like AB, each stock requires it's own .csv file--not a combined file.
AA would produce a .csv file with ALL the stocks in 1 file---yes?? but
then maybe i'm missing what you are trying to tell me. i can be pretty
dense at times. i have not tried to use what you suggest---but i will try
it.
<font size=2
face="Times New Roman">
<font size=2 color=blue
face=Arial>PFScan
does not include a stock downloader---it depends on another independent program
to fetch the data. iow, there is no AQ with PFScan. i has a few
"formats" which it can use, but they must be specified and it is very
specific.
<font size=2
face="Times New Roman">
<font size=2 color=blue
face=Arial>For what
i want---the easiest way to do it would be have AQ do it, --download the data,
import it into AB, AND create/append a .csv file.
<font size=2
face="Times New Roman">
<font size=2 color=blue
face=Arial>Really
now that i think about it all---this was a pretty stupid question--it really
has nothing to do with AB....
<font size=2
face="Times New Roman">
<font size=2 color=blue
face=Arial>thanks
for trying---
<font size=2 color=blue
face=Arial>ron
<font size=2
face="Times New Roman">
<font size=2
face="Times New Roman">
<font size=2
face="Times New Roman">
-----Original Message-----
From: Jayson
[mailto:jcasavant@xxxxxxxxxxx]
Sent: Wednesday, March 31, 2004
3:14 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: RE: [amibroker] Re: OT:
Does anyone use PFScan? if so, how do you download data?
<font size=2 color=blue
face=Arial>Ron,
<font size=2 color=blue
face=Arial>perhaps
I am still lost :(
<font size=2
face="Times New Roman">
<font size=2 color=blue
face=Arial>lets say
you have downloaded 100 or 1000 stocks from your vendor into an AB watch
list called "my stocks". Now lets say your PF program requires OHLC
data plus Volume. In AA,using addcolumn, you define the appropriate fields in
the appropriate order then run the exploration for the whole watchlist or
database. You can then export that whole report as a csv file that can be read
or imported into your PF software.
<font size=2
face="Times New Roman">
<font size=2 color=blue
face=Arial>Regards,
<font size=2 color=blue
face=Arial>Jayson
<font size=2
face="Times New Roman">
Send BUG REPORTS to
bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to:
amiquote@xxxxxxxxxxxxxxx
(Web page: <a
href="">http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: <a
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/amibroker/
To unsubscribe from this group, send an email to:amibroker-unsubscribe@xxxxxxxxxxxxxxx
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
|