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
$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: mroman59@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
**** IMPORTANT PLEASE READ ****
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/
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