Using the smfPricesBetween function, I noticed that the 08 field (Close Price) returns Yahoo's Adj. Close Price (adjusted for dividends) instead. Is it...
10376
Randy Harmelink
rharmelink
Jun 1, 2010 10:14 pm
Nope, sorry. To tell the truth, I find very little use for actual closing prices, so I pretty much ignore them....
10377
Jim Palmer
orpalms44
Jun 2, 2010 2:14 am
Randy, Thanks very much for your helpful reply. I removed the Add-ins from C:\Users\[me]\ApplicationData\Roaming\Microsoft\Add-Ins and started over. I got...
10378
Randy Harmelink
rharmelink
Jun 2, 2010 2:42 am
... That looks correct. ... That looks correct. ... Nope. The SMF add-in doesn't provide you with any menu options, so there's no reason for it to be there. In...
10379
newengwongpeggy
Jun 2, 2010 4:13 am
Hi Randy, I have encountered the following problem. While I was pressing F8 to run each macro line one by one. Even though there is no RCH related function...
10380
Randy Harmelink
rharmelink
Jun 2, 2010 4:52 am
I don't really see a problem with what you're describing. The "Calculate" statement is an event that could trigger any number of add-in functions. That looping...
10381
Gerard
glmillz
Jun 2, 2010 9:18 pm
I've found some barchart value codes, but I've been unable to find anything that will display individual stock RSI values. Of course I could just be...
10382
Randy Harmelink
rharmelink
Jun 2, 2010 9:43 pm
Relative Strength is a rather nebulous term. You can use RCHGetElementNumber() to retrieve the values from a page such as this: ...
10383
danwahoo2
Jun 3, 2010 6:14 pm
With the SMF Add-In, can we auto retrieve current Dividends and 10-Year EPS Growth? If so, can you direct me to a link? Thanks....
10384
Randy Harmelink
rharmelink
Jun 3, 2010 6:26 pm
Dividend yield: =RCHGetElementNumber("MMM";, 13935) 10-year average EPS growth: =RCHGetElementNumber("MMM";, 14342) Both of those elements come from Morningstar,...
10385
kurtd66
Jun 4, 2010 4:00 am
Hi Is there any way of assigning the add-in to a macro button rather then installing it as a add-in Cheers Dennis...
10386
futurehou
Jun 4, 2010 4:00 am
The term =RCHGetTableCell("http://finance.yahoo.com/bonds/composite_bond_rates", 1,">Corporate Bonds",">20yr AAA", ">20YR AA") does not report correctly for me...
10387
Randy Harmelink
rharmelink
Jun 4, 2010 4:02 am
I'm not sure what you're asking. The add-in is primarily a collection of user-defined functions, which can't be assigned to a button......
10388
Randy Harmelink
rharmelink
Jun 4, 2010 4:04 am
It's working fine for me -- returning "N/A", which is exactly what the Yahoo page has on it....
10389
a_chauhan86
Jun 4, 2010 8:44 am
hello randy, I was using the following to put charts from www.stockcharts.com. ...
10390
Randy Harmelink
rharmelink
Jun 4, 2010 9:06 am
That's because I get a "URL not found" when I use the URL you're creating for the RCHGetWebData() function. ...
10391
a_chauhan86
Jun 4, 2010 10:09 am
Ok there might have been a mistake in URL, but when i am still getting #VALUE with following as well. ...
10392
Randy Harmelink
rharmelink
Jun 4, 2010 12:11 pm
Try something like this for the first formula: =RCHCreateComment("http://stockcharts.com/"&LEFT(RCHGetWebData(" http://stockcharts.com/h-sc/ui?c= ...
10393
timothydull
Jun 4, 2010 3:37 pm
I am a new user and having trouble adding these functions to be implemented automatically as an add-in. I have Vista Business and excel 2007. When I follow...
10394
Randy Harmelink
rharmelink
Jun 4, 2010 4:07 pm
To solve location problems, the "Find and Replace All" process is the most reliable: http://finance.groups.yahoo.com/group/smf_addin/message/4918 However, the...
10395
Gerard
glmillz
Jun 4, 2010 4:48 pm
Why do you say it's nebulous? RSI measures the internal strength of the stock. The calculation is straightforward. I've been using it for the past four years...
10396
Randy Harmelink
rharmelink
Jun 4, 2010 7:00 pm
There are many other ways to measure relative strength. For example, a relative strength from IBD is a completely different animal. And Faber uses a variety of...
10397
cory
cjridlen
Jun 5, 2010 5:15 pm
I get nothing but ERRORs and #VALUE's from from this worksheet. I am using the most updated add-in, have excel set to auto-update formulas, tried multiple...
10398
Randy Harmelink
rharmelink
Jun 5, 2010 6:11 pm
That's because it primarily uses AdvFN elements, and they recently changed their website. I should have moved that file to the "Works in Progress" folder. In...
10399
Jim Palmer
orpalms44
Jun 6, 2010 1:03 am
Absolutely great! This is my first experience with your add-in and it is fabulous. The add-in that I described that creates in a tab on the spreadsheet...
10400
flyingmelons
Jun 6, 2010 2:25 am
Hey Bud or Budette, I initially had the same challenges with some of the templates. A quick check of "6.0 - Templates.html"; in the "Files" section of this...
10401
flyingmelons
Jun 6, 2010 2:25 am
Hello, I also recently joined this group (two hours ago) and was having trouble with some of the templates. The 6.0 - Templates.html help file, the first file...
10402
smortonm
Jun 6, 2010 2:58 pm
HI: I tried the formula you outlined in the files you uploaded on 6/5/10 and it does not seem to be working. I entered: =smfGetOptionQuotes("NYXJul 2010 $29...
10403
Peter Gum
phgyh
Jun 6, 2010 3:32 pm
Hi Randy, I'm on Windows 7, Excel 2007. This: =smfGetYahooOptionQuote("IBM","P",DATE(2010,6,19),130,"l") gives me this: "Bad expiration date: 40348" This...
10404
Randy Harmelink
rharmelink
Jun 6, 2010 3:44 pm
Sorry -- I uploaded the documentation, but not the new add-in yet......
