i use the function: =RCHGetYahooHistory($D$21, YEAR($H$21), MONTH($H$21), DAY($H$21), YEAR($F$21), MONTH($F$21), DAY($F$21)) where d21=ELAL.TA f21=Wed 2-Sep-09...
At http://www.ftportfolios.com/retail/dp/dpsummary.aspx?fundid=6067 a 3 line table is returned. The table header is: Income Information The second line is the...
Just use the general form: =RCHGetTableCell(URL,column,">CUSIP",,,,1) ...with the URL as needed for different "fundid" values and vary column from 1 to 7 for...
Anyone have any comment on what equity risk premium you are using these days in your models? I thought I had been out of the securities analysis business, but...
Hi, I am new in the group I it would be great if someone could help me with this issue_ At http://finance.yahoo.com/etf/browser/hl?f=0&c=etf_sr&cs=1&ce=14 What...
Try something like this to grab the P/E column: =RCHGetTableCell(" http://finance.yahoo.com/etf/browser/hl?c=0&k=5&f=0&o=d&cs=1&ce=999 ",4,">"&$B6&"<") ...
The add-in only has 1000 slots to save web pages for data extraction. Once you hit that many, it can no longer retrieve more web pages until those slots are...
I see ... thanks for the information, I will give the smfForceRecalculation macro a try. Justin ... Once ... those ... otherwise ... from ... didn't ... that...
Is anyone else noticing that the http://ogres-crypt.com/ php dump page isn't working or is it just me? I can't even load any data from the browser. Just real...
I just tried your link and it worked fine for me. However, we did have a recent thread about sporadic results from AdvFN. They may still be having problems....
This could be done with a looping macro with an external query within. Pretty fast. Don Guillett Microsoft MVP Excel SalesAid Software dguillett1@......
Yahoo only provides the data page by page, so you'd need to do some type of iteration -- say, using something like RCHGetHTMLTable() or RCHGetTableCell(). I...
To extract components AND OHLCV, you could use YF  #1 => Extract number of components  B2: =RCHGetWebData(" To extract components AND OHLCV, you could use...
You could try some searching with Google. It's how I found the NYSE link... Otherwise, you may need to try one of the other suggestions made in the thread....
How about the Yahoo Industry Browser -- both sector and industry groups: http://biz.yahoo.com/p/s_conameu.html Or, similar presentations from Finviz: ...
Is there a way of retrieving the Net Asset Value (NAV) from the Summary page in Yahoo Finance? See this for example: http://finance.yahoo.com/q?s=SPY Thanks, ...
Hi Randy, How do I go about gaining risk grades for any stock at <http://www.riskgrades.com/retail/quote-riskchart.cgi> If the website address had the stock...
Randy Recently, Morningstar purchased an extensive closed-end fund research data service. They have made the research available for their Premium subscribers....
I have no idea where the closed-end fund data even is... As far as the portfolio data -- no elements. The data is not delivered as a table, but built from...
