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 ...
3860
feshipley
Apr 1, 2008 1:58 pm
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...
3861
Randy Harmelink
rharmelink
Apr 1, 2008 2:55 pm
Not that I'm aware of......
3862
Martin Topper
mtopper
Apr 2, 2008 8:54 pm
Randy Morningstar has changed the Business Risk rating to "Fair Value Uncertainty". I would like to retrieve this new datapoint using the following formula....
3863
Randy Harmelink
rharmelink
Apr 2, 2008 9:53 pm
You're searching for the wrong string. Try: =RCHGetTableCell("http://quicktake.morningstar.com/Stock/PrintReport.asp?Country=USA&Symbol="&A7,1, "Fair Value...
3864
ttivanwan
Apr 3, 2008 2:49 am
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...
3865
Randy Harmelink
rharmelink
Apr 3, 2008 3:39 am
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...
3866
wabmester
Apr 3, 2008 4:04 am
Hello. I'm trying to get the yield for a mutual fund. 5063 seems to work for some funds, but not for others. For example: ...
3867
Randy Harmelink
rharmelink
Apr 3, 2008 4:39 am
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...
3868
wabmester
Apr 3, 2008 4:54 am
Aha! The old keyword embedded in the name trick. Thanks -- that fixed it!...
3869
nlavery
Apr 3, 2008 3:27 pm
The template spreadsheet, SMF-Template-RCHCreateComment-Charts- Layout.xls, is very nifty and contains 16 6-month charts from StockCharts.com. My question is...
3870
Randy Harmelink
rharmelink
Apr 3, 2008 3:43 pm
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...
3871
junholeelee
Apr 3, 2008 11:43 pm
Hi, I'm wondering how to get CurrentStock Price into Excel. http://kr.stock.yahoo.com/sise/srh_list.html?query ...
3872
Randy Harmelink
rharmelink
Apr 4, 2008 12:00 am
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...
3873
junholeelee
Apr 4, 2008 12:29 am
Thank you for repling,Randy. B21 has http://kr.stock.yahoo.com/sise/srh_list.html?query=»ï¼ºÀüÀÚ =RCHGetWebData(B21,"</form>") <td...
3874
Randy Harmelink
rharmelink
Apr 4, 2008 1:10 am
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...
3875
junholeelee
Apr 4, 2008 1:57 am
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...
3876
imanbogor
Apr 4, 2008 2:06 am
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...
3877
Randy Harmelink
rharmelink
Apr 4, 2008 2:08 am
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...
3878
imanbogor
Apr 4, 2008 2:24 am
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...
3879
Randy Harmelink
rharmelink
Apr 4, 2008 3:02 am
Very easy -- you would just use the normal RCHGetYahooQuotes() function, using BUMI.JK as your ticker symbol....
3880
imanbogor
Apr 4, 2008 3:17 am
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...
3881
Randy Harmelink
rharmelink
Apr 4, 2008 3:25 am
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...
3882
Iman Chandra
imanbogor
Apr 4, 2008 3:29 am
I see... Again, thanks a lot randy. Nice to read the answer directly from the master....:) With cloudy rainy from Jakarta, Iman...
3883
junholeelee
Apr 4, 2008 11:28 am
Hi,Randy. Wow! Thank you for your help. =RCHGetTableCell(B21,2,"</form>","chart") Retrieve accruate value. Regards/Junho Lee....
3884
Don Guillett
donaldb36
Apr 4, 2008 12:00 pm
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...
3885
Don Guillett
donaldb36
Apr 4, 2008 12:12 pm
Ignore this. I didn't see the later posts. Don Guillett Microsoft MVP Excel SalesAid Software dguillett1@... ... From: Don Guillett To:...
3886
"What's in a...
jpsartrean
Apr 4, 2008 5:29 pm
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...
3887
"What's in a...
jpsartrean
Apr 4, 2008 6:02 pm
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...
3888
Randy Harmelink
rharmelink
Apr 4, 2008 6:38 pm
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, ...
