Hello,
"once you populate your database and this data becomes outdated or when you add new symbols, you will have manually have to make changes over time as this information changes."
That is NOT true. With version 6.0 and above, a SINGLE menu item (Tools->Update US symbol list and categories)
updates in place existing symbols, adds any new symbols and updates all category (markets/sectors/industries) assignments.
So instead of reinventing the wheel - upgrade AmiBroker to latest version.
Best regards,
Tomasz Janeczko
amibroker.com
I would like to update my database for sector and industry using Yahoo or other websites API. I am running AB's version 5.4. Even with the newer version of Amibroker, once you populate your database and this data becomes outdated or when you add new symbols, you will have manually have to make changes over time as this information changes.
It appears that what I need is a script that will download the symbol, name, sector and industry from Yahoo's or other website that provides this data into a CSV file. Once I have this CSV file, I can them use the ASCII import function in Amibroker to populate and update my database. I would have to import using the format definition below during the process.$FORMAT Ticker, FullName,SectorName,IndustryName
$SEPARATOR ,
$AUTOADD 1
$NOQUOTES 1
$OVERWRITE 1
$CLEANSECTORS 1
$SORTSECTORS 1
If you just want ticker, name , sector and industry that this should be a pretty easy script to write. I don't need the historical or price data or any fundamental data of course.
Could anyone provide me with a method or write this script for me or at least get me started on how to do it.Any suggestions are appreciated. I have contacted some programmers in the past and they said this would be easy, however they never responded back with price or interest it appears.
Thank you and your support is much appreciated,MR
Posted by: Tomasz Janeczko <groups@amibroker.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
This group is for the discussion between users only.
This is *NOT* technical support channel.
TO GET TECHNICAL SUPPORT send an e-mail directly to
SUPPORT {at} amibroker.com
TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)
For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/
EmoticonEmoticon