ETF - download fullname

Hi Victor,
I was able to pull the entire *******star mutual fund ticker symbol and full name database down about a year ago as a csv and you can then use the import wizard to enter it into your database. I don't see a way to attach a csv file here, anyone who wants it can feel free to reach out to me at roylance3@gmail.com. It's from April of 2017, and has about 26,000 tickers in it with descriptions.
Tony

1 Like

You wouldn't have an updated link for this would you? It looks like NASDAQ has changed their website and importing a list is no longer available.

Hi MCassICT,

on the new site I haven't seen it either, but there is still an old version available: https://old.nasdaq.com/etfs/list
RioL

2 Likes

Just use Tools->Update US symbol list and categories. It includes full name.

1 Like

Well now, I just took Tomasz advise and used Tools->Update US symbol list and categories. At the time I was using my Mutual Fund data base that contained only some mutual funds and ETFs, about 25 total. But after following the advise, that data base now contains 6827 equities. So I must remake my original data base. I hope that I will be able to just copy and paste from the bloated folder to a new one. I can easily find the original equities because I can search and sort based on file length. :frowning_face:

Look at fxhrats post, should be 3/4 down. As long as you didn’t download data for the unwanted symbols, the instructions for database purify should work for your case.

If you worried about the data, not a bad idea to copy a backup of the database folder your using.

@Metamega, I believe you posted this last item to PanoS to the wrong thread.

For just updating the company name, Yahoo Extra is fine but I think it truncates.

1 Like

@TraderX, thank you very much for the suggestion. However, I'm unfamiliar with Yahoo Extra and couldn't find anything about it on the web. Could you please point me to it?
BTW, I receive most forum comments via email. Your recent post contained 7 or 8 paragraphs. However, on the forum website, where I am now, only the last sentence is visible (???).
Thanks again, -- Keith

I wrote a long post but then decided to delete it as it contained too much proprietary hard work, so keep it private please.

image

1 Like

@TraderX, that did the trick. Thank you very much for your help. -- Keith

Hi Tomasz,
I just purchased AmiQuote but found for many ETFs the Full Name are missing, such as S&P 500 sector ETFs(XLF,XLE,...) and 3x leveraged ETFs ( TQQQ, SPXL, ...). I did tried the Tools->Update US symbol list and categories but it doesn't work. Maybe you need to update the database of US symbol list and categories? Can you please let me know what the best way to download the Full Name?

Yahoo Historical data download does NOT include full name.

Tools->Update US symbol list and categories is basically for stocks only.

For ETFs you would need to get the full names from somewhere else in plain text form and import them http://www.amibroker.com/guide/h_impwizard.html

By the way, your question is already answered earlier in this thread: Download fullname (post#2) and it includes instruction and link to Nasdaq site where you can get ETF names from.

Also, I have prepared a list of NYSE traded ETFs here (symbol, fullname) here: NYSE_Traded_ETFs.txt so you can import them using Import Wizard directly.

Thanks, Tomasz! It works.

Yahoo historical data, has problem in o h l c of candles
20200410_163256

@shan, as you probably know, AmiBroker is not a provider of data.

If you are unsatisfied by the quality of the free Yahoo EOD data, you can try different subscription-based data sources like Tiingo or Norgate, etc.

I suggest to explore the "Data Sources" sections of the forum to learn more about the different data providers.

2 Likes

Anytime I’ve questioned a data problem, I go to yahoo’s website and click view historical data. It’s in a table format. The issue is yahoos data every time. Unfortunately amiquote can’t fix yahoo. You can try and ask yahoo to fix it but it’s free and they really don’t care.

This particular problem looks like download using OUTDATED format (with incorrect split adjustment). The advice is:

  1. Install MOST recent AmiQuote version
  2. Re-download everything from start (Set the "FROM" date to earliest back date you want)
1 Like

Beppe,
Thanks -- when I visit that link -- I don't see a way to download the Sector info for ETFs. Where on their site is the download link?
Gary

@Gary, the Nasdaq site was changed.

As reported in a subsequent message by @RioL, at the moment of this writing, you can still access the data from this link:

https://old.nasdaq.com/etfs/list

(I don't know if that list is still a current one).

2 Likes