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: 22734
  • Category: Software
  • Founded: Jun 18, 2006
  • Language: English
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Message search is now enhanced, find messages faster. Take it for a spin.

Messages

Advanced
Messages Help
Messages 3112 - 3141 of 22355   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand Author Sort by Date ^
3112 mgbuck55 Send Email Nov 2, 2007
8:02 pm
Hi Randy, I have to begin by thanking you most sincerely for generously sharing your wonderful VBA code with the world. I have written some Excel VBA download...
3113 Randy Harmelink
rharmelink Send Email
Nov 2, 2007
10:06 pm
I was able to get to a smaller URL for the frame address. However, although ... Const kURL = "http://apps.cnbc.com/view.asp?uid=stocks/earnings&symbol=IBM" ...
3114 mgbuck55 Send Email Nov 3, 2007
12:47 pm
Good Morning Randy, Wow, I banged my head against a wall for a day and a half on this and you came up with something in a couple of hours. While you may not ...
3115 Randy Harmelink
rharmelink Send Email
Nov 3, 2007
2:49 pm
... It was the "link" that was attached to the "onMouseOver&quot; attribute for each bar on the graph, so I just decided to try it as-is. To tell the truth, I...
3116 Randy Harmelink
rharmelink Send Email
Nov 3, 2007
10:36 pm
Just thought I'd mention another site I just ran into that may be easier to get data from, although only 4 quarters of future estimates: ...
3117 dab_mango Send Email Nov 4, 2007
1:12 am
I have tried using =RCHGetTableCell ("http://finapps.forbes.com/finapps/jsp/finance/compinfo/Earnings.jsp? tkr="&$A2,2,"Estimated Fiscal Earnings",,,2,) By...
3118 L.V.Gandhi
lvgandhi Send Email
Nov 4, 2007
1:17 am
Hats off to you Randy from another retired fellow. I just came across your group for stock market jobs as I am learning it after retirement. Though I didn't...
3119 Randy Harmelink
rharmelink Send Email
Nov 4, 2007
2:05 am
... That particular formula worked fine for me on the 14 tickers I tried it on: MMM4.97 ERES0.29 IBM6.97 MRO6.03 ASPV4.24 ENH6.81 CFI0.54 HWCC1.59 TX4.38 ...
3120 mark hanesn
markhansen_l... Send Email
Nov 4, 2007
2:20 am
I THINK I'M GETTING CLOSER. AS A REMINDER I AM USING EXCELL 2007 WITH XP AND AM NOT SURE IF THE DOWN LOAD IS IN THE RIGHT PALCE I HAVE NOT YET BEEN ABLE TO USE...
3121 dab_mango Send Email Nov 4, 2007
2:26 am
Thanks a lot ! I was not using ">" in front of Table Name. As a consequence, results were unpredictable to say the least ! It is obviously an "User Error" due...
3122 dab_mango Send Email Nov 4, 2007
3:00 am
I tried using following function =RCHGetTableCell("http://finapps.forbes.com/finapps/AccountingRisk.do? tkr="&$A$33,C$2,">AGR",,,,$B33) Where $A$33 = "DRYS" ...
3123 Randy Harmelink
rharmelink Send Email
Nov 4, 2007
5:13 am
No need to skip rows, or even columns for that matter, to get the data. They have both the "AGR" description and the value in the same table cell. This works...
3124 Randy Harmelink
rharmelink Send Email
Nov 4, 2007
5:21 am
Although not recommended, you can put the add-in anywhere you want. However, if you don't use the recommended directory, you will have problems using workbooks...
3125 mark hanesn
markhansen_l... Send Email
Nov 4, 2007
5:56 am
I PRINTED THE ATTACHED EMAIL AND TRIED TO FOLLOW IT EXACTLY, BUT I GOT 'FILE RCH_STOCK_MARKET_FUNTIONS&#39; IS PASSWORD PROTECTED'. PLESE ENTER PASSWORD. PLEASE...
3126 mark hanesn
markhansen_l... Send Email
Nov 4, 2007
7:03 am
IN ADDITION TO THE BELOW I HAVE REDOWN LOADED THE FILES AND IT STILL GIVES ME THE MESSAGE UNABLE TO OPEN HTTP://F1.GRD.YAHOOFS.COM/PROGRAM FILES\SMF...
3127 Randy Harmelink
rharmelink Send Email
Nov 4, 2007
7:08 am
There is no password on the ZIP file....
3128 Randy Harmelink
rharmelink Send Email
Nov 4, 2007
7:10 am
That sounds like you are trying to open one of the XLS template files. You would get a message similar to that until you have the add-in activated. It can't...
3129 jprowley1 Send Email Nov 4, 2007
6:16 pm
Hi Randy, What is the best way to get beta, yield, expense ratio, and opening/closing prices for MF/ETFs? Thanks, Jeff...
3130 Randy Harmelink
rharmelink Send Email
Nov 5, 2007
1:38 am
These element numbers should help, although the expense ratio item only works for mutual funds: *# **Source**Element* 5099YahooRKFund Risk -- Beta -- 3-Year --...
3131 Jeffrey Rowley
jprowley1 Send Email
Nov 5, 2007
2:22 am
Thanks Randy. FYI - I want to capture beta, expenses etc, for each fund then calculate my portfolio's beta & expenses. Last question, is it possible to...
3132 Randy Harmelink
rharmelink Send Email
Nov 5, 2007
2:30 am
Sure. Easiest way is probably to use the smfPricesBetween() function. For example, if the ticker symbol is in cell A1 and the date is in cell B1, then this...
3133 ssancheti Send Email Nov 5, 2007
3:38 am
Hi Randy, I just started using the add-In functions to get the financial data from advfn website using your template. if a company has data for >5 yrs but...
3134 Randy Harmelink
rharmelink Send Email
Nov 5, 2007
3:52 am
Possible, but not trivial. AdvFN presents their data in the reverse mode of most other services so it's not easy to go backward other than in multiples of 5....
3135 rjlabs Send Email Nov 5, 2007
4:15 pm
Sector and Industry Encoding Looking through the selection of sector and industry codes I see there are a few alternatives. Here would be my list of "nice to...
3136 mgbuck55 Send Email Nov 5, 2007
4:34 pm
Thanks for the link to the Forbes site. I visited the page you linked and it looks like yet another great source for data. I feel like a kid in a candy store...
3137 jjwin77 Send Email Nov 5, 2007
9:58 pm
Randy, I only use 2 of the functions in your add-in (incredible job, by the way). Is there an easy way to import those functions into my workbook so I don't...
3138 Randy Harmelink
rharmelink Send Email
Nov 5, 2007
10:01 pm
It would depend on the functions. I have been looking at slicing and dicing everything into "atomic" modules so that it would be easier to separate them out....
3139 bohra_anand Send Email Nov 6, 2007
6:29 am
Hi Randy can u pl make custom function or give me guidance that how to extract this URL Data in your functions. This site i found is for getting live data of...
3140 Randy Harmelink
rharmelink Send Email
Nov 6, 2007
7:03 am
Why wouldn't you just grab it directly from the source page using RCHGetTableCell()? As far as I can tell, the URL you gave is just a preprocessor that gets...
3141 anand bohra
bohra_anand Send Email
Nov 6, 2007
9:22 am
Thank you very much Best Regards, Anand M. Bohra ... From: Randy Harmelink <rharmelink@...> To: smf_addin@yahoogroups.com Sent: Tuesday, 6 November, 2007...
Messages 3112 - 3141 of 22355   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