3 Messages
Digest #3928
1b
Re: Fwd: [justcoveredcalls] Re: New file uploaded to justcoveredcall by "Randy Harmelink" rharmelink
Messages
Thu Feb 23, 2017 7:02 pm (PST) . Posted by:
bobc94595
Thanks, Randy. Keyboard Shortcut revealed: C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetOptionQuotes(rOptTicker,"b",,LEFT(rSource,1))
I removed: C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!, and it worked. Did the same on Bid Price, Extrinsic, Profit and aROI, and they work. Corrected all the other definitions similarly, and they all seem to work.
Still trying to understand the utility of spreadsheet. Can you elaborate on your message 26927, including the dividend plays section where the dividend is .80, but the need is .71
Thanks again
I removed: C:\SMF Add-in\RCH_
Still trying to understand the utility of spreadsheet. Can you elaborate on your message 26927, including the dividend plays section where the dividend is .80, but the need is .71
Thanks again
Thu Feb 23, 2017 11:25 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Interesting. It never occurred to me that the path to the add-in would be
added to those defined names. But it makes sense. And I don't think my
smfFixLinks macro would fix those links. I'll have to rethink using SMF
formula in defined names.
I'll answer the other question on the options group, since it applies to
options and not the add-in functions.
On Thu, Feb 23, 2017 at 8:02 PM, conlonrc@
...wrote:
>
> Thanks, Randy. Keyboard Shortcut revealed: C:\SMF Add-in\RCH_Stock_Market_
> Functions.xla'!smfGetOptionQuotes(rOptTicker,"b",,LEFT(rSource,1))
> I removed: C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!, and it worked.
> Did the same on Bid Price, Extrinsic, Profit and aROI, and they work.
> Corrected all the other definitions similarly, and they all seem to work.
>
> Still trying to understand the utility of spreadsheet. Can you elaborate
> on your message 26927, including the dividend plays section where the
> dividend is .80, but the need is .71
>
>
Interesting. It never occurred to me that the path to the add-in would be
added to those defined names. But it makes sense. And I don't think my
smfFixLinks macro would fix those links. I'll have to rethink using SMF
formula in defined names.
I'll answer the other question on the options group, since it applies to
options and not the add-in functions.
On Thu, Feb 23, 2017 at 8:02 PM, conlonrc@
...wrote:
>
> Thanks, Randy. Keyboard Shortcut revealed: C:\SMF Add-in\RCH_
> Functions.xla&#
> I removed: C:\SMF Add-in\RCH_
> Did the same on Bid Price, Extrinsic, Profit and aROI, and they work.
> Corrected all the other definitions similarly, and they all seem to work.
>
> Still trying to understand the utility of spreadsheet. Can you elaborate
> on your message 26927, including the dividend plays section where the
> dividend is .80, but the need is .71
>
>
Fri Feb 24, 2017 5:51 pm (PST) . Posted by:
sjagers
Hi Randy... Thanks for updating smf-elements-6.txt. GetElements 850 works for me, now.
During your absence, I used GetTagContent to retrieve Zacks Industry info. My Excel formula is:
smfGetTagContent("https://www.zacks.com/stock/research/"&$S23&"/industry-comparison","strong",1,">Industry :")
... where cell "S23" contained the symbol to lookup.
My formula has been working for several weeks, including just a few days ago, but it's returning an Error today.
Any idea why it's not working now?
Thanks. Glad you're back. Hope you're doing well.
During your absence, I used GetTagContent to retrieve Zacks Industry info. My Excel formula is:
smfGetTagContent("https://www.zacks.com/stock/research/"&$S23&"
... where cell "S23" contained the symbol to lookup.
My formula has been working for several weeks, including just a few days ago, but it's returning an Error today.
Any idea why it's not working now?
Thanks. Glad you're back. Hope you're doing well.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar