Page 1 of 1

Fetching stock data into EViews

Posted: Thu Jan 07, 2010 10:57 am
by EViews Gareth
This program fetches stock data into EViews from the Yahoo Finance website. It is presented here primarily as a way of demonstrating how the @uidialogs and word list functions in EViews 7 can be used to build some pretty powerful programs. However you may find it a useful tool for fetching stock data into EViews!

Note, this program requires EViews 7 to run.

I'd appreciate any comments you have, or suggestions on how it could be improved!

Re: Fetching stock data into EViews

Posted: Sat Jan 16, 2010 2:20 pm
by terrya
QMS Gareth wrote:This program fetches stock data into EViews from the Yahoo Finance website. It is presented here primarily as a way of demonstrating how the @uidialogs and word list functions in EViews 7 can be used to build some pretty powerful programs. However you may find it a useful tool for fetching stock data into EViews!

Note, this program requires EViews 7 to run.

I'd appreciate any comments you have, or suggestions on how it could be improved!


Hi
I've just installed EV7 and run the program. It's nifty. I would like to be able to get indices such as SP500 etc. I tried altering the url to get the right address and failed. Any ideas?

Re: Fetching stock data into EViews

Posted: Mon Jan 18, 2010 2:06 pm
by EViews Gareth
Well you can get indices by entering the symbol for those indices. The problem, though, is that most indices' symbols start with a "^" character (^GSPC for S&P500, I think), which is an illegal EViews name character. Thus the @recode part of my wfopen and import statements won't work.

I'm currently stumped on how to get around that elegantly, but until a more elegant solution presents itself, the attached modification will do.

Re: Fetching stock data into EViews

Posted: Mon Jan 18, 2010 3:20 pm
by terrya
QMS Gareth wrote:Well you can get indices by entering the symbol for those indices. The problem, though, is that most indices' symbols start with a "^" character (^GSPC for S&P500, I think), which is an illegal EViews name character. Thus the @recode part of my wfopen and import statements won't work.

I'm currently stumped on how to get around that elegantly, but until a more elegant solution presents itself, the attached modification will do.


I have now run it and its works well enough for me. My problem initially was the ^.

Re: Fetching stock data into EViews

Posted: Tue Dec 07, 2010 5:54 am
by oek_stat
I can't download the price of ETFs like the iTraxx Europe 5-Year (DXSR.DE).
Perhaps there is a problem with points because the download of the stock price of BASF (BAS.DE) also doesn't work.