Stocks Data base

June 11th, 2012, 12:59 PM

Amiuser

You can keep those lists up to date very easily by yourself as you mentioned that you were a programmer. Here is an example Amibroker - import Finviz stock lists of how it could be done via AFL and using finviz The new app looks like this with one added option Urlget can be downloaded from AB website Location of the extracted zip files is Amibroker directory.

Is this utility available for Big Mike's Elite members?

August 29th, 2012, 08:43 PM

Hi,
I am very new to Amibroker. After downloading the zip file I tried to istall it used tools/customized/tools entered Finviz as new tool, then added C:\Program Files\AmiBroker\URLGet.zip in command line and also in initial directory. It gave me "you have to define url and local file name in program arguments". also tried with exe file with C:\Program Files\AmiBroker\URLGet.exe as command and C:\Program Files\AmiBroker as initial directory but the same result. Please let me know what I'm doing wrong.

October 19th, 2014, 08:02 PM

Why doesn't AmiBroker already have this code built into it or does anyone need these categories for trading? Maybe the AmiBroker programmers don't think it's needed and pointless to pursue it.

=========================================

Amiuser

You can keep those lists up to date very easily by yourself as you mentioned that you were a programmer.
Here is an example Amibroker - import Finviz stock lists of how it could be done via AFL and using finviz Free Stock Screener
The new app looks like this with one added option

Then the AFL removes the quotations (button 2 of my AFL).

Before creating a data base containing symbols with sector and industry info you would need to create one custom broker.sectors and one custom broker.industries files according to Finviz' Morningstar Industry Classification (backup the old broker files before).

The content of the finviz broker.sectors file looks like this (Undefined Sectors is an addition by me for symbols that have no sector/industry assignment (that was a tip by Market Monk, thanks btw) ):

Undefined Sector
Basic Materials
Conglomerates
Consumer Goods
Financial
Healthcare
Industrial Goods
Services
Technology
Utilities

the same one as a picture and with additional info

So this is pretty short and simple

The broker.industries file is larger. One click of the third button of my AFL and it gets formated using the finviz raw file seen above.

The formated broker.industries file looks as follows (needs to be in place before new database creation) :

This is a snippet of the formated symbols list (button 4 of my AFL)

The last thing you need is the format file to import the symbols of the symbols list (format file saved as i.e. finviz_NYSE.format or just finviz.format to the Formats folder of AB. Format is the file extension):

Code

$FORMAT TICKER,FULLNAME,Skip,INDUSTRY,Skip,Skip,Skip 
$SKIPLINES 1 
$BREAKONERR 1 
$AUTOADD 1 
$NOQUOTES 1 
$MARKET 0 
$OVERWRITE 1 
$SEPARATOR |

the same one as picture

the same AFL (of the video) can be used for any provided symbols list like the ones downloaded from here
NYSE Companies - [AUTOLINK]NASDAQ[/AUTOLINK].com

If you don't need sectors and industries assignments at all then it's even much more simpler to import own/external lists of symbols

November 7th, 2014, 04:47 PM

Good stuff mate. Where I can download this AFL file mate ?

Amiuser

the same AFL (of the video) can be used for any provided symbols list like the ones downloaded from here

Stocks Data base

Discussion in Platforms and Indicators

Stocks Data base