[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [amibroker] Re: jrswindle us-stock database updater



PureBytes Links

Trading Reference Links



Thank you Dick...just thought I would ask because I think others were developing a yahoo downloader..
 
I know nothing about VBA.....I tried jims excel downloader but have compile errors when trying it....
 
Anthony
 
----- Original Message -----
From: areehoi
Sent: Sunday, June 14, 2009 9:04 AM
Subject: [amibroker] Re: jrswindle us-stock database updater

Anthony,
Maybe this will help. This is what Jim posted on his site with ref to download of Yahoo data

"The Stocks_XLS spreadsheet has the VBA source included in it to extract the data needed from the Yahoo financial website. It was developed on XP with Excel 2003.

For those that know VBA, run the modExtract.RunExtractor to pull the data in from the website. This uses a simple (and crude) Internet Explorer pull to open the webpage and pull in the data. It then loops through each of the Sectors, then drills down into the Industries, and lastly goes out and pulls each Company information down. Since this using plain VBA for all extraction, it is very slow. Expect 12 hours to do an extract...

Next run the modAB.AB_Start to take the data from the spreadsheet and copy it into the AmiBroker database. This takes about a minute or less.

The source is provided as is. You may modify it anyway you want and redistribute it as you see fit. There is no guarantee that it will work or of any errors in the code. Additionally, we are not related in way with AmiBroker software and cannot answer questions about it."
I am not familiar with "VBA" but that seems to be the key. Hopefully you or someone can figure out so we can update fro Yahoo.

Dick H.

--- In amibroker@xxxxxxxxxps.com, "Anthony Faragasso" <ajf1111@xxx> wrote:
>
> Has anyone done anything with the database updater that Jim was kind enough
> to share with the forum...
>
>
> Anthony
>



__._,_.___


**** 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/





Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___