AmiBroker

[darkhorse70]

Thanks trash . Ill get in youch with norgate.

Thank you Howard. Very helpfull pdf.

Haha tech, well im already on the path of self educating and main stream uni books have been a waste for me so far (5% was usefull). Better invested in such books as these.

 

[darkhorse70]

So I bought amibroker standard edition. Im trying to import yahoo historical data but for some reason it keeps giving me an error.


Im trying to save it under an csv file but it seems to have some trouble in that format. Not sure whats going on. Any ideas?

Would amiquote remove all that hastle?

 

[SuperGlue]

Be easier to use Amiquote.

To import csv files, I use import wizard,
Data format is:

BHP,141201,30.59,30.59,29.26,29.27,14515746

Set your Field type for date format as per your csv file, eg. YMD, DMY or MDY.

If data is from Yahoo you'll have to insert "Ticker name" and delete "Adj close"

Hope this works for you.

 

[howardbandy]

So I bought amibroker standard edition. Im trying to import yahoo historical data but for some reason it keeps giving me an error.


Im trying to save it under an csv file but it seems to have some trouble in that format. Not sure whats going on. Any ideas?

Would amiquote remove all that hastle?

Hi Darkhorse --

AmiBroker prefers to have its data in a database. You can read csv files on-the-fly, but that is more difficult to program and not very efficient. Superglue's recommendation that you use AmiQuote is correct.

There is a section in my Introduction book that gives instructions for setting up the database using free quotes from Yahoo and AmiQuote. Download the book from its website:
http://www.introductiontoamibroker.com/

Best regards,
Howard

 

[darkhorse70]

Thanks superglue/howard. Ill give that a go superglue. Howard I was following your intro to amibroker but I most likely missed something as my young brother who is studying programming in high school was assisting me.

But ill get my hamds on amiquote. Will amiquote provide me all the data quickly or is it still a slow manual process?

Thanks

 

[howardbandy]

Hi Darkhorse --

To use AmiQuote:
Type in or import a list of tickers.
Set the date range.
AmiQuote goes to Yahoo, Google, or msn and downloads at the speed of your internet connection.
AmiBroker imports them in a second or two.

Next time is just an update to bring all tickers current, so it is much faster.

Best,
Howard

 

[howardbandy]

Darkhorse, and all --

I see some references to Norgate Premium Data in the recent message postings. Premium Data is Much higher quality than Yahoo. Use Yahoo while you are playing with free trial AmiBroker. If you decide to keep AmiBroker, consider subscribing to Premium Data. They do all the data maintenance and automatic downloading without any action on your part whenever data is ready. It is well worth the subscription fee.

Best,
Howard

 

[darkhorse70]

Ok thanks for the feedback Howard. Will do on both parts.

 

[darkhorse70]

Ok so was able to import the files from amiquote to amibroker automatically. The easy part done lol.

Thanks for the feedback.

 

[darkhorse70]

One last question. How do I download an entire index of stock without having to do so one by one manually using amiquote?

 

[darkhorse70]

all good. just going to go through the whole tutorial. ThaNKS

 

[Habakkuk]

One last question. How do I download an entire index of stock without having to do so one by one manually using amiquote?

I believe you create a file e.g. ASX100.tls with all the tickers you want and open that file in AmiQuote.
There are some samples in the folder, like Djia.tls FTSE100.tls Nasdaq100.tls
Then you click on the green arrow button to start

 

[darkhorse70]

Thanks Haba. Makes sense.

 

[darkhorse70]

ok so im having some issues getting all the symbols list of the nyse/dowi/nasdaq/ etc so I can create a file. Wondering if anyone already has a saved file of that on amiquote and would be kind enough to pm it to me? Thanks

 

[Wysiwyg]

One last question. How do I download an entire index of stock without having to do so one by one manually using amiquote?

This is the easiest way I think.

1) Download the ticker list which is in .txt. format I have attached below onto your desktop screen.
2) Open that notepad list -> Go to File -> Save As and add .tls at the end of name All Ords in the lower File Name box. Now Save. This creates an Amiquote file. Q
3) Leave that for now.
4) Open Program Files -> Amibroker and create New Folder. Call this folder All Ords. Close Program Files.
5) Open Amibroker and in the top left is File drop down menu. In that File menu, click 'Open Database'. In the Browse for Folder box which appears, find the folder Amibroker and then the folder you just created 'All Ords'. Click on that and OK. There should be a blank screen because no data is available yet.
6) Now up at the top dropdown menus again you will see Tools -> and click on Auto update Quotes (Amibroker only).
7) Amiquote will open. In the top left of Amiquote screen is dropdown File menu. Click on Open... and navigate via 'Look In' to your desktop screen. On the desktop is the .tls file we created earlier in step 2. Click on that and the tickers will appear in Amiquote window ready for download from Yahoo.
8) Go to File dropdown menu again and Save As -> Save In -> navigate to Amiquote folder in Program Files/Amibroker/Amiquote. Save in Amiquote folder as .tls file.

Now this is the big moment.

In the source menu on the Amiquote screen, set to Yahoo Historical EOD. Also set From / To.
Click on the triangular icon to Start Download.

This will take a bit of time but you can speed it up by going to in Amiquote -> Tools -> Settings -> and make the 'Number of Simultaneous Downloads' 10.

Your friend, Wysiwyg.

p.s. If yahoo download shows no data available for any stock it is Yahoo at fault because the list I attached is up to present day from Premium Data.

 

[darkhorse70]

haha thanks wysiwig. Ill give it a shot now. Appreciate it mate.

 

[darkhorse70]

Thanks wysiwyg. Done and done.

 

[darkhorse70]

One last question wysigwyg. Im trying to save the actual amibroker file, the one with the all ords data but when I try to save it, the file is not readable. What format do I save it in so I can re open it later?

 

[Wysiwyg]

Save As Type: Text Documents (*.txt) to your desktop screen.

 

[darkhorse70]

Thanks wysiwig. Saved. Unfortunately when I tried to open the data as a chart it gave an error. I think it has to do with yahoo as you said. On another note, how did you get that list for the all ords. I just want to back test my strategies so if I could try it on other indexes which will work such as the American indexes then its some sort of progress.

Thanks