EViews.com

Fantastic. Thanks a million.

I cannot download commodity futures or indices. Is everything on Yahoo Finance able to be downloaded?

Which indices?

Love this code, you guys are awesome. I tweaked the code a little (tweaked code attached) so that it pullls australian stock market data rather than US (can't just use the icharts .ax suffix as this would imply a period in the output eviews object names). australian users might find it useful.

nifty.

Would it be even better if you combine the two programs by adding an "Australia or United States" radio button on the ui?

Even better would be a drop down with a whole bunch of countries to select from.

I'm a bit tied down with other projects at the moment, but I'll put some thought into a refresh at some point in the future (unless anyone else wants to take a stab).

Would it be even better if you combine the two programs by adding an "Australia or United States" radio button on the ui?

i could probably do that actually, there are only a few lines needed changing... just have a radio button attached to a !market = 1, have "if !market >0 then /bla bla bla with the .ax suffix/ else /"bla bla bla without the .ax" /endif each time the lines come up...

i was just adding in some code to pulll mcap and book/val ratios (lil bit more tricky), i might get back to the us/aus switch afterwards

If you're fiddling around with the code, somewhere in there I put in a hack to allow stocks with names that EViews doesn't like: This could probably be change to use the @makevalidname function, which would handle all illegal characters, rather than just a starting "^". That might help you out with your periods too.

If you're fiddling around with the code, somewhere in there I put in a hack to allow stocks with names that EViews doesn't like:

Code: Select all

if @left(%stock,1) = "^" then 'handle the case where a stock name starts with "^", which is an invalid EViews name. %stock = "_" + @mid(%stock,2) endif

This could probably be change to use the @makevalidname function, which would handle all illegal characters, rather than just a starting "^". That might help you out with your periods too.

I saw that, v. clever but I think the radio button solution is probably the way to go (if only because i can default it to .ax, saves me having to add .ax all the time!). Most users probably arent familiar with the icharts .ax suffix as it is so keeping it simple is probably better - but of course adapting your hack would allow (i presume) the use of ALL the stocks on the icharts db, pretty cool.... hmmm...

Added new features.

While this change might seem great to some, it appears that you have destroyed some of the flexibility of the previous version. Previously, I had no trouble downloading mixed currency stocks (e.g. ^nz50,^aord,^gspc,^nyse, ....etc). Now I can't. So a number of programmes that used the old version have been rendered useless. Do you think you could resore the previous version under a new name perhaps.

It shouldn't have broken anything. We'll fix it.

Until then, I've uploaded the old one here

The problem is that us stocks have to have us currency, nz stocks nz currency, aussie stoocks aussie currency, etc. I liked the old programme because I could download sp500, nz50, aord etc into a single workfile and EViews did the date matching for me to make it easier to get a common sample. The new version can't do this. I've included a sample of code to show you what I've been able to do. Also, it seemed to me that the new add-in didn't always create a new workfile when I wanted it to so do.

Just used you quick-fix and it works as in the past.