3 Messages
Digest #3274
Messages
Tue Dec 23, 2014 12:18 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The best way is to use the smfForceRecalculation macro. See the "Tips and
FAQs" web page for more information on that macro.
On Tue, Dec 23, 2014 at 1:03 PM, megaloellhnas@...wrote:
>
>
> Thanks Randy! This is way better than the old MSN Money add-in I've used
> for years.
>
> One other quick questions, how I do manually (or automatically) have all
> the data (retrieved from Yahoo) update so I can see the latest prices?
>
FAQs" web page for more information on that macro.
On Tue, Dec 23, 2014 at 1:03 PM, megaloellhnas@
>
>
> Thanks Randy! This is way better than the old MSN Money add-in I've used
> for years.
>
> One other quick questions, how I do manually (or automatically) have all
> the data (retrieved from Yahoo) update so I can see the latest prices?
>
Tue Dec 23, 2014 4:30 pm (PST) . Posted by:
adiabatic76
Hello Randy,
I have been successfully using for several years:
=IF(smfGetOptionQuotes($A1,"b")="N/A",0,smfGetOptionQuotes($A1,"b"))
to obtain option quotes. This works when A1 contains:
NCR Jan 2015 $30 Call
However, options quotes for February 2015 and beyond don't work. Example:
CGNX Feb 2015 $40 Call
I just updated the add-in, but still the same problem. Any suggestions? Thanks!
Shreeder
I have been successfully using for several years:
=IF(smfGetOptionQuo
to obtain option quotes. This works when A1 contains:
NCR Jan 2015 $30 Call
However, options quotes for February 2015 and beyond don't work. Example:
CGNX Feb 2015 $40 Call
I just updated the add-in, but still the same problem. Any suggestions? Thanks!
Shreeder
Tue Dec 23, 2014 4:40 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
See item (3) in
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/27582
You'd need a beta version of the add-in from after 2014-09-15 or later to
have the "Feb" translate properly.
Unfortunately, the 2104.10.23.B version of the add-in doesn't work with
Yahoo after they backed out the IE changes to the option page formats.
The best work-around at this point is to code the exact expiration date.
On Tue, Dec 23, 2014 at 5:30 PM, adiabatic76@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> I have been successfully using for several years:
> =IF(smfGetOptionQuotes($A1,"b")="N/A",0,smfGetOptionQuotes($A1,"b"))
>
> to obtain option quotes. This works when A1 contains:
> NCR Jan 2015 $30 Call
>
> However, options quotes for February 2015 and beyond don't work. Example:
> CGNX Feb 2015 $40 Call
>
> I just updated the add-in, but still the same problem. Any suggestions?
> Thanks!
>
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/27582
You'd need a beta version of the add-in from after 2014-09-15 or later to
have the "Feb" translate properly.
Unfortunately, the 2104.10.23.B version of the add-in doesn't work with
Yahoo after they backed out the IE changes to the option page formats.
The best work-around at this point is to code the exact expiration date.
On Tue, Dec 23, 2014 at 5:30 PM, adiabatic76@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> I have been successfully using for several years:
> =IF(smfGetOptionQuo
>
> to obtain option quotes. This works when A1 contains:
> NCR Jan 2015 $30 Call
>
> However, options quotes for February 2015 and beyond don't work. Example:
> CGNX Feb 2015 $40 Call
>
> I just updated the add-in, but still the same problem. Any suggestions?
> Thanks!
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar