Skip to search.

Breaking News Visit Yahoo! News for the latest.

×Close this window

smf_addin · EXCEL Stock Market Functions Add-in

The Yahoo! Groups Product Blog

Check it out!

Group Information

  • Members: 22957
  • Category: Software
  • Founded: Jun 18, 2006
  • Language: English
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Real people. Real stories. See how Yahoo! Groups impacts members worldwide.

Messages

Advanced
Messages Help
Messages 3859 - 3888 of 22663   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand Author Sort by Date ^
3859 edwardudell Send Email Apr 1, 2008
11:01 am
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 Send Email 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 Send Email
Apr 1, 2008
2:55 pm
Not that I'm aware of......
3862 Martin Topper
mtopper Send Email
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 Send Email
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 Send Email 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 Send Email
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 Send Email 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 Send Email
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 Send Email Apr 3, 2008
4:54 am
Aha! The old keyword embedded in the name trick. Thanks -- that fixed it!...
3869 nlavery Send Email 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 Send Email
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 Send Email 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 Send Email
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 Send Email 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 Send Email
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 Send Email 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 Send Email 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 Send Email
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 Send Email 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 Send Email
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 Send Email 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 Send Email
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 Send Email
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 Send Email 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 Send Email
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 Send Email
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 Send Email
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 Send Email
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 Send Email
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, ...
Messages 3859 - 3888 of 22663   Oldest  |  < Older  |  Newer >  |  Newest
Add to My Yahoo!      XML What's This?

Copyright © 2010 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines NEW - Help