Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
I just heard about a data downloader that links to Yahoo Real Time and Yahoo 15 min delayed. It's called [COLOR=blue][B]RTQDownloader V1.5[/B][/COLOR]. Does anyone know if this will work with AmiBroker? It works with Bull's Eye Broker and I only want to buy one data downloader; instead of the regular downloaders that are usually purchased with these platforms.
Can you help answer these questions from other members on NexusFi?
I used it a couple years ago when I was still trading stocks, IMO it was serious pos, but they may have improved it since then. Just a thought, but can Amibroker connect to TDA? If you open an account with TDA, in addition to live feed you get 2 years of minute data and 10+ years of daily data. I'm guessing that you probably don't even have to fund it. I have a TDA account with a $0 balance that I still can access the data. If you do have to fund it to activate it, then just fund the minimum and turn around and drain it. This way you could have a free live data feed.
Yes, it is possible to link AmiBroker and TOS; however, I haven't been able to save all the live data. The only data that is saved is the data I backfill with Yahoo. Real time date is not saved from previous days, I have to use historical data from Yahoo. Once you exit AmiBroker, all the real time data that you were looking at is gone. For that matter can [COLOR=blue][B]RTQDownloader V1.5[/B][/COLOR] do what I need? You said that you used RTQDownloader; please clarify, did you use it with AmiBroker and were you able to save all the TICK data, both current and historical backfills? Are you still using AmiBroker?
You can try to export the data that you see realtime and then import it again into another database.
Here is a program that I have written, that is pretty simple and can be modified to chose a specific scrip, set of scrips or all scrips.
Posting the code below, as I couuldnt figure how to post a file and the attachments dont support .afl extensions.
//change the directory to whatever you like
fmkdir( "C:\\OHLC" );
//Buy = DateNum() >= 0 AND DateNum() >= 1120101 AND DateNum()<1120101;
//Edit following line to choose the date range that you would like Buy = DateNum() >= 0 ;//AND DateNum() >= 1120101 ;//AND DateNum()<1120101;
j=0; for( i = 0; i < BarCount; i++ )
// comment uncomment your custome if statement to choose the appropriate scrips. if( Buy[i] )
//if( Buy[i] AND (Name()=="NIFTY_F1" OR Name()=="NIFTY" OR Name()=="BANKNIFTY_F1" OR Name()=="MINIFTY_F1"))
//if( Buy[i] AND Name()=="BANKNIFTY_F1")
//if( Buy[i] AND Name()=="NIFTY")
// Do not touch any of the lines below
{
fh = fopen( "C:\\OHLC\\"+Name()+".txt", "a"); if( fh )
{
y = Year();
m = Month();
d = Day();
r = Hour();
e = Minute();
for( i = 0; i < BarCount; i++ ) if( Buy[i] )
{
// if (j==0)fputs("<Ticker>,<Date>,<Time>,<Open>,<High>,<Low>,<Close>,<Volume>\n",fh); if (j==0)fputs("<Ticker>,<Date>,<Time>,<Open>,<High>,<Low>,<Close>,<Volume><OpenInterest>\n",fh);
j=j+1;
fputs( Name() + "," , fh );
ds = StrFormat("%02.0f%02.0f%02.0f,",
y[ i ], m[ i ], d[ i ] );
fputs( ds, fh );
ts = StrFormat("%02.0f:%02.0f,",
r[ i ],e[ i ]);
fputs( ts, fh );
// qs = StrFormat("%.2f,%.2f,%.2f,%.2f,%.0f\n",//%.0f\n",
qs = StrFormat("%.2f,%.2f,%.2f,%.2f,%.0f,%.0f\n", O[ i ],H[ i ],L[ i ],C[ i ],V[ i ],OpenInt[i] );
fputs( qs, fh );
}
fclose( fh );
}
}
Would you happen to know the YQL code to download historical quotes in ASCII - MetaStock format? -- Symbol, Periodicity, Date, Open, High, Low, Close, Volume, Open Interest
There are software providers in the Indian market who provide yahoo historical data for both intraday and EOD data.
I will check and post, once I get a link, which should help with international scrips.. I used to use such a provider for EURUSD data, but they packed up.
May I ask how you are able to get TOS or TDA data into AmiBroker? I'm on the brink of starting a trial with AmiBroker, and don't see TDA / TOS as one of their data providers... Thanks much.
SJ, thanks for the info. Really good to know. Since this does not include historical data, I assume you use Yahoo! or the like as well... Thanks again.