Hi Leon, You suggested ...use Excel function Search to find each column heading... Not sure I understand. You are saying that under the column heading ...
I just downloaded this and ran it with 2.0h. None of the Business Week data is retrieved. I guess this is because BW quit offering their stock screener. Is...
Randy Morningstar has changed the Business Risk rating to "Fair Value Uncertainty". I would like to retrieve this new datapoint using the following formula....
You're searching for the wrong string. Try: =RCHGetTableCell("http://quicktake.morningstar.com/Stock/PrintReport.asp?Country=USA&Symbol="&A7,1, "Fair Value...
hi, I am a new gay, I don't know how to how to get lastest exchange rate from bloomberg excel add-in ....I just can find the information of getting price of...
Can't help on the Bloomberg add-in. This is a support form for the SMF add-in. However, you could get the quotes from Yahoo using the SMF add-in. For...
It's because that fund is described as a "High Yield Bond". The definition of the elements says to find ">Fund Overview" (the table header), then search for...
The template spreadsheet, SMF-Template-RCHCreateComment-Charts- Layout.xls, is very nifty and contains 16 6-month charts from StockCharts.com. My question is...
You can code your own chart definitions. The items in the template use a predefined chart layout, which I created just for convenience. If I were to hard-code...
I don't think I can be of help. There are just too many foreign symbols on the page, which makes it difficult for me to even tell what is there. Plus, I...
But even your URL below is displaying as garbage, so I can't be sure what your "query" parameter is. When I click on the URL without the "query" parameter...
Hi,Randy. I made formula like below. A39 cell has ticker. =MID(RCHGetWebData("http://kr.stock.yahoo.com/sise/srh_list.html? query="&A39,"<table>"),FIND("<td...
Hi, I'm totally new here. I have loaded the SMF Add-in. I need to retrieve the Asian Market data from Yahoo.My question is how to identify the stock exchange...
How do you use your browser to view Jakarta data from Yahoo right now? A URL or example would give me a better idea of how the add-in might be used to get the...
Thanks for your quick response, Randy. Here the URL example that I use: http://finance.yahoo.com/q?s=BUMI.JK The code for Jakarta Stock Exchange in Yahoo is...
Really thanks, Randy. It's work now..but I can't get the data when I enter in the template. For example, I open the SMF-Template-1--Year-Charts. I change IBM...
That's because that ticker symbol is only valid for Yahoo. It's unlikely it will work for any other data source, and for very few of the templates in the...
I went there with your url and got this. If correct, it appears that you must KNOW the number at the end which probably may be harvested by inputing the symbol...
Unfortunately stockhouse.com - a site which I subscribe to and use for Canadian stock data - has changed the format of its pages dramatically, and now I can't...
Was able to get Canadian data off of advfn - but would still prefer pulling it from stockhouse as I believe it is more accurate and updated more frequently...
Wow. What a mess. They are coding each column of each subsection as its own table. This formula appears to grab the table cells, varying "row" as 1,3, 5, ...