NexusFi: Find Your Edge


Home Menu

 





Stocks Data base


Discussion in Platforms and Indicators

Updated
      Top Posters
    1. looks_one Amiuser with 10 posts (10 thanks)
    2. looks_two timmymagic07 with 6 posts (0 thanks)
    3. looks_3 colion with 2 posts (0 thanks)
    4. looks_4 StockJock with 2 posts (0 thanks)
    1. trending_up 18,083 views
    2. thumb_up 10 thanks given
    3. group 9 followers
    1. forum 23 posts
    2. attach_file 0 attachments




 
Search this Thread

Stocks Data base

  #1 (permalink)
Amiuser
New York NY
 
Posts: 21 since Mar 2012
Thanks Given: 3
Thanks Received: 10

Here is an empty data base of US stocks Download US Stocks.zip You just need to download the data (e.g. Amiquote). The symbols are sorted by industries and sectors. It's an empty data base someone made one year ago. So it's not up to date since there are also OTC stocks included so if a firm doesn't exist anymore no (current) data will be available. But of course there are also major firms included that have been existing for years and decades.

What to do with the zip file?

Unzip it and put broker.industries, broker.sectors and us_stocks.tls to ... Program Files\Amibroker
Put the import.types and the tls.format file to ... Program Files\Amibroker\Formats folder

Create a new folder called USStocks or anything similar and put it to i.e. ....Program Files\Amibroker or wherever you want it to be. Then start Amibroker and create a new data base (File>New>DataBase). 'Browse' to the USStocks folder you have created before, open it and press save. (Un-)check 'Load data base at startup'. Then press 'Create'.

Now choose data source (most probably 'local data base' as it gets updated via Amiquote). Base time interval EOD but you can choose any other interval.

Now go to File>Import ASCII, click on it, choose file type US_Stocks (*.tls) and browse to the us_stock.tls file located in ....Program Files\Amibroker. Then click open. The stock symbols will be getting imported. But the data base will be still empty so the last thing to do is to start Amiquote ( Tools>Auto update quotes (Amiquote only) ). Choose download range there and start downloading. Of course you can explore other settings of Amiquote before downloading.

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
The space time continuum and the dynamics of a financial …
Emini and Emicro Index
Build trailing stop for micro index(s)
Psychology and Money Management
ZombieSqueeze
Platforms and Indicators
Online prop firm The Funded Trader (TFT) going under?
Traders Hideout
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
59 thanks
Funded Trader platforms
37 thanks
NexusFi site changelog and issues/problem reporting
23 thanks
GFIs1 1 DAX trade per day journal
22 thanks
The Program
19 thanks
  #2 (permalink)
Amiuser
New York NY
 
Posts: 21 since Mar 2012
Thanks Given: 3
Thanks Received: 10

If you for example just need stocks of S&P 500 then here there is the .tls file for that Download S&P 500.tls
Put it to the Amiquote folder, then start Amibroker and Amiquote and in Amiquote choose that tls file (File>Open).

Reply With Quote
  #3 (permalink)
 
TonyB's Avatar
 TonyB 
Bay Area, CA - US
 
Experience: Beginner
Platform: TOS, TS & MC
Broker: TDA & TS
Trading: Stock, Options and now Futures (ES)
Posts: 516 since Dec 2010
Thanks Given: 227
Thanks Received: 140


Good stuff Amiuser. Thanks for the helpful how-to. I like how it utilizes industries and sectors. I usually get current NYSE, NASDAQ and AMEX listings from the web, I believe on NASDAQ's website, downloadable...

Reply With Quote
  #4 (permalink)
timmymagic07
London, United Kingdom
 
Posts: 37 since Apr 2012
Thanks Given: 6
Thanks Received: 21

Hello,

TonyB - FYI you can also find some additional useful .TLS files here;

<had to remove url as I do not have 5 posts, but simply google "how to use amiquote" and select the third link, bottom of the page are extra *.TLS files, you have probably seen them already, but just in case.../>

I, like you, am looking into AmiBroker as a solution for my needs. I will be longer term trading/investing, so only need a platform that deals with EOD data (preferably the free stuff!) that is also cost effective. So far this would appear to be the best option, along with ProTA, but I do not have a Mac.

It would be nice if they had up to date *.TLS files for FTSE100, FTSE350, Europe, etc. considering they charge a fee for AmiQuote, but it would appear they do not. It wouldn't take too much effort to keep them up to date, assuming you put in the effort to create them in the first place, but it is still effort I would rather not have to make..

Having said that - I have been in contact with customer support with no word on additional sources of .TLS files, having asked, but I do not suppose there are a selection on their forums perhaps? Amiuser, perhaps you might be able to shed some light on this?

I am a programmer by trade, albeit very early into my career, so AmiBroker certainly appeals in that sense, I just don't want to go spending hard earned cash until I am happy it is the right decision.

Reply With Quote
  #5 (permalink)
Amiuser
New York NY
 
Posts: 21 since Mar 2012
Thanks Given: 3
Thanks Received: 10

They don't charge a monthly fee for Amiquote. It's a one time price for that ticker downloader. By additional providing and keeping all thousands of world wide tickers up-to-date T.J. would have a lot less time being available to improve his software. I wouldn't like that. Even more so since I'm not into stocks that much. The standard data base provides index and stocks examples of the US market so it's up to the user to add additional ones. But here are some worldwide ticker lists that you can use Download tickers worldwide.rar There is a read me file included. So yeah read it.

Reply With Quote
  #6 (permalink)
timmymagic07
London, United Kingdom
 
Posts: 37 since Apr 2012
Thanks Given: 6
Thanks Received: 21

Cheers Amiuser, that's useful.

Are these generally kept up to date by users on the yahoo group at all?

Reply With Quote
  #7 (permalink)
Amiuser
New York NY
 
Posts: 21 since Mar 2012
Thanks Given: 3
Thanks Received: 10

One general note in regards to broker.sectors and broker.industries files of the Amibroker installation folder. Those two files are needed only for creating a data base. After creating of a DB those two files of the .rar archive or any other custom made ones are not needed anymore so the two backed up standard files that are part of the standard installation of Amibroker can be "re-installed".

Reply With Quote
  #8 (permalink)
Amiuser
New York NY
 
Posts: 21 since Mar 2012
Thanks Given: 3
Thanks Received: 10


timmymagic07 View Post
Cheers Amiuser, that's useful.

Are these generally kept up to date by users on the yahoo group at all?

Ask Market Monk of the yahoo group of AB. He keeps a data base up to date and is providing it to other users. I think he is charging a small donation of around $20. But I don't remember what kind of stocks are included. I think he is an American. So I guess his DB mainly consists of US stocks but ask him.

Reply With Quote
  #9 (permalink)
Amiuser
New York NY
 
Posts: 21 since Mar 2012
Thanks Given: 3
Thanks Received: 10

Another note you can download symbol lists from finviz and simply import them into AB, also can download lists from official US market websites. There was a thread about on the yahoo list recently. I will look at it.

Reply With Quote
  #10 (permalink)
 
TonyB's Avatar
 TonyB 
Bay Area, CA - US
 
Experience: Beginner
Platform: TOS, TS & MC
Broker: TDA & TS
Trading: Stock, Options and now Futures (ES)
Posts: 516 since Dec 2010
Thanks Given: 227
Thanks Received: 140


timmymagic07, I appreciate the follow-up, thank you.

If I had such a programming background, such as yourself, AB would have most likely been my platform of choice. Best to you.

Reply With Quote




Last Updated on November 7, 2014


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts