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...
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...
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,...
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...
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)...
Take a look at the RCHGetYahooHistory() function -- something like: =RCHGetYahooHistory("VFINX",,,,,,,"v") ...would return: Date Dividends 2010-12-23 $0.49...
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...
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...
... 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...
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...
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...
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...
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 ...
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...
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...
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 ...
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. ...
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...
It's right in the source code of the add-in: Case "Magic Formula Investing -- Earnings Yield" n1 = RCHGetElementNumber(pTicker, 949) ' Enterprise value to ...
Ahhh -- the ""The first of the month for the option expiration month you want" processing was obsoleted when weekly expirations became available, because the...
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...
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...
