Rabu, 24 Desember 2014

[smf_addin] Digest Number 3274

3 Messages

Digest #3274
1a
Re: Current Price? by "Randy Harmelink" rharmelink
2a
SMF Option by adiabatic76
2b
Re: SMF Option by "Randy Harmelink" rharmelink

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?
>

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


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!
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar