Shift-F9 worked! The only function I am using is RCHGetYahooQuotes, so it works in this instance. Thanks for your help....
14087
Bob
kosharikids
Apr 1, 2011 3:11 pm
Look at this solution, it explains several alternatives: http://www.decisionmodels.com/calcsecretsh.htm...
14088
tambourman2001
Apr 1, 2011 4:36 pm
First of all, love this add-in!, makes my life so much easier. At the moment I'm trying to pull in the weekly option bid asks, and the only place i've found so...
14089
Randy Harmelink
rharmelink
Apr 1, 2011 4:50 pm
I looked at Google options when I wrote the smfGetOptionQuotes() function. Unfortunately, they deliver the data dynamically to the page, so it's not in the...
14090
David Van Aken
tambourman2001
Apr 1, 2011 5:04 pm
I appreciate your help, as always. What is the syntax to look for the weekly option quote for april? I think I'm suppose to put a /W somewhere in the pTickers,...
14091
David Van Aken
tambourman2001
Apr 1, 2011 5:20 pm
I figure it out, I should have checked the message history now that I had a different question. I was able to pull it by: =smfgetoptionquotes("SPY 4/1 2011...
14092
prosuite
prosuite2000i
Apr 1, 2011 5:33 pm
I guess you already figure it out but  adding &output=json to the URL may help ...  ... From: Randy Harmelink <rharmelink@...> Subject: Re:...
14093
canesbr
Apr 1, 2011 6:10 pm
Hi. Newbie here. Is there a function to get the distribution history from a mutual fund? (a) Like the one on Yahoo that supplies date and total dividends (b)...
14094
Randy Harmelink
rharmelink
Apr 1, 2011 6:57 pm
Thanks for the clue! General form of extraction: =0+smfStrExtr(smfStrExtr(RCHGetWebData(" http://www.google.com/finance/option_chain?q= ...
14095
Randy Harmelink
rharmelink
Apr 1, 2011 7:05 pm
Take a look at the RCHGetYahooHistory() function -- something like: =RCHGetYahooHistory("VFINX",,,,,,,"v") ...would return: Date Dividends 2010-12-23 $0.49...
14096
canesbr
Apr 1, 2011 7:12 pm
Thanks Newbie question - I select a range and do an array enter on the formula to get results? Is that the way to do it? If so I am guessing the dimensions of...
14097
Randy Harmelink
rharmelink
Apr 1, 2011 8:04 pm
Correct on both counts...it will blank-fill any excess rows....
14098
hashky
Apr 1, 2011 9:18 pm
Does anyone know how to calculate this? Do you have a spreadsheet? I used the Option Strategy.xls written by g_sorbara in the Forum User Uploads. I have had...
14099
rex
bios007a
Apr 1, 2011 11:06 pm
... Hi Ron, NP. Unfortunately I fairly often inadvertently irritate people. ... I started programming later, in the mid-70s using a DEC LSI-11 that my partner...
14100
rex
bios007a
Apr 1, 2011 11:11 pm
... Sorry about that. :( -rex --...
14101
Randy H
rharmelink
Apr 2, 2011 6:41 am
I uploaded a new beta version (2.1.2011.04.01) of the add-in to the "Works in Progress" folder. It now has an smfGetGoogleOptionQuote() function and Google can...
14102
Randy H
rharmelink
Apr 2, 2011 4:10 pm
1. Only their symbol lookup process, as far as I know. 2. Check out barchart.com On Sat, Apr 2, 2011 at 8:13 AM, James O'Connor <jfoconnor99@...> wrote: I...
14103
PLA
option2z
Apr 2, 2011 7:39 pm
Randy, How cool! I tried the new google option retrieval, but can only get parts of it to work. For instance ...
14104
Randy Harmelink
rharmelink
Apr 2, 2011 7:48 pm
When I look at Google Finance right now, there are no 2011-04-01 options shown, so I would expect blanks to be returned. I've also found out that "T" as a...
14105
PLA
option2z
Apr 2, 2011 8:02 pm
Ron & Rex, Yep, I'm trying to make money (but it is still an experiment.I'm trying to learn to optimize my trades.). My educational background is operations ...
14106
mkorgie
Apr 3, 2011 1:48 pm
Randy ... just a heads-up if you're not already aware. Several sector weighting titles have been renamed and/or realigned on the Morningstar summary page...
14107
Joel
joelfp2000
Apr 3, 2011 4:05 pm
Randy, Thanks again for all of your help! I'm interested in your magic formula data (element #15013 and 15014). Is it possible to construct a worksheet that...
14108
Randy Harmelink
rharmelink
Apr 3, 2011 4:25 pm
Thanks for the note. I just uploaded the new smf-elements-4.txt definition file in the "Works in Progress" folder of the files area. 2010-04-03...
14109
Randy Harmelink
rharmelink
Apr 3, 2011 4:39 pm
I wouldn't rely on those two elements -- they were kind of a shot from the hip. But, no, you shouldn't be using them to filter stocks. It would be too much ...
14110
Joel
joelfp2000
Apr 3, 2011 10:30 pm
Thanks, Your "shot from the hip" seems pretty right on. I have used them and compared them to the MagicFormulaInvesting.com and they seem pretty correct. ...
14111
Pete
option2z
Apr 3, 2011 11:01 pm
Thanks, Randy. Red face; don't even know what day it is (Sunday today...not yesterday). =smfGetGoogleOptionQuote($D$6,"C",DATE(2011,4,1),30,"l") is the...
14112
Randy Harmelink
rharmelink
Apr 3, 2011 11:36 pm
It's right in the source code of the add-in: Case "Magic Formula Investing -- Earnings Yield" n1 = RCHGetElementNumber(pTicker, 949) ' Enterprise value to ...
14113
Randy Harmelink
rharmelink
Apr 4, 2011 12:13 am
Ahhh -- the ""The first of the month for the option expiration month you want" processing was obsoleted when weekly expirations became available, because the...
14114
Randy Harmelink
rharmelink
Apr 4, 2011 12:22 am
PS: Related to the new functions -- I uploaded this file to the JustCoveredCalls Yahoo group yesterday: SMF-Template-Google-Options-CC-Returns.xls It creates a...
14115
johnsz32
Apr 4, 2011 4:37 am
I purchased a new computer (ASUS N53S) with 64 bit windows operating system. After installing the RCH_Stock_Market_Functions identical to my old computer...
