Rabu, 10 Agustus 2016

[smf_addin] Digest Number 3765

10 Messages

Digest #3765

Messages

Tue Aug 9, 2016 4:55 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Recent File updates on the SMF Add-in Website <http://ogres-crypt.com/SMF/>:
*Folder* *Filename* *Description*

RCH_Stock_Market_Functions-2.1.2016.08.07.zip Latest official relase of the
add-in.
2016-07-13: Updated for Yahoo's option quotes page redesign.
2016-08-07: More Yahoo option page changes, new smfGetYahooPortfolioView
function

Install-the-addin.html How to install the add-in
Documentation Change-Log.html Change log for add-in
Documentation smfGetOptionQuotes-Function.html Function to return a range
of options data items to worksheet cells, based on a list of special option
ticker symbols and data codes. For example, this would return the bid and
ask prices on the specified options contract:

=smfGetOptionQuotes("SPY 12/19 2015 $190 Call","ba")
Templates smfGetYahooPortfolioView-Multiple-Expirations-By-Strike-Prices.xls An
options tool that retrieves multiple expirations and strikes for a ticker
symbol, using the smfYahooPortfolioView() function.
Templates smfGetYahooPortfolioView-Example.xls Simple example of using the
smfGetYahooPortfolioView() function.

Tue Aug 9, 2016 5:03 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Oops, forgot to mention that currently the only documentation on the
smfGetYahooPortfolioView() function is here:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30599

The templates won't work for you as they do for me, unless your Yahoo "v1"
Portfolio view is the same as mine. Right now, my fields in that view are:

TIME & PRICE
CHG & % CHG
DAY'S LOW & HIGH
VOLUME
AVG VOL
MKT CAP
BID
ASK
YIELD
DIV/SHARE
EX-DIV DATE
P/E
PRICE/SALES
1-YR TRGT PRICE

On Tue, Aug 9, 2016 at 4:55 AM, Randy Harmelink <rharmelink@gmail.com>
wrote:

> Recent File updates on the SMF Add-in Website
> <http://ogres-crypt.com/SMF/>:
> *Folder* *Filename* *Description*
>
> RCH_Stock_Market_Functions-2.1.2016.08.07.zip Latest official relase of
> the add-in.
> 2016-07-13: Updated for Yahoo's option quotes page redesign.
> 2016-08-07: More Yahoo option page changes, new smfGetYahooPortfolioView
> function
>
> Install-the-addin.html How to install the add-in
> Documentation Change-Log.html Change log for add-in
> Documentation smfGetOptionQuotes-Function.html Function to return a range
> of options data items to worksheet cells, based on a list of special option
> ticker symbols and data codes. For example, this would return the bid and
> ask prices on the specified options contract:
>
> =smfGetOptionQuotes("SPY 12/19 2015 $190 Call","ba")
> Templates smfGetYahooPortfolioView-Multiple-Expirations-By-
> Strike-Prices.xls An options tool that retrieves multiple expirations and
> strikes for a ticker symbol, using the smfYahooPortfolioView() function.
> Templates smfGetYahooPortfolioView-Example.xls Simple example of using
> the smfGetYahooPortfolioView() function.
>

Tue Aug 9, 2016 5:49 am (PDT) . Posted by:

john_hoel

I get HTTP 404 when I try to download the zip.

Tue Aug 9, 2016 8:40 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Oops. Uploaded it to the wrong folder. Sorry.

Should be there now.

On Tue, Aug 9, 2016 at 5:49 AM, john@
​...wrote:

>
> I get HTTP 404 when I try to download the zip.
>
>

Tue Aug 9, 2016 9:07 am (PDT) . Posted by:

john_hoel

I installed the new version, replacing the previous version, and now the SMF functions are not recognized. I get '#NAME?&#39; when I run the "Version" operation, and the context menu does not have the SMF functions.

Tue Aug 9, 2016 9:21 am (PDT) . Posted by:

john_hoel

After several restarts, the functions now work. I think I had to recalculate the entire sheet to make it work.

Tue Aug 9, 2016 10:50 am (PDT) . Posted by:

john_hoel

False alarm. After several restarts, it now works.

Tue Aug 9, 2016 5:07 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I'm not sure what to suggest other than exiting EXCEL and restarting it.
The context menu loads when the add-in is loaded. I would thought that
would have happened when you added it back in. But I have no idea what
"pkug" is or what specifically you did to "remove and add the addin back
in"...

On Mon, Aug 8, 2016 at 11:03 PM, neil@
​...wrote:

>
> I had some weird prblem with the pkug and had to remove and add the addin
> back in. in the process I Lost the SMF menu item from the context-menu in
> Excel - the one with that allosw you to select whether to recalculate the
> selection workbook etc.
>
> Looking for help in getting back.
>
>

Tue Aug 9, 2016 11:14 am (PDT) . Posted by:

bkipersztok

Hello -


I use =smfGetOptionQuotes to pull options prices for various securities. One of the securities I've been pulling is VXX.


For example, let's say I have "VXX Jan 2017 74 Call" in cell A2, and in another cell, I pull its ask price using =smfGetOptionQuotes(A2,"a",0,"OX2").


Today, VXX went ex-dividend on a 1-for-4 reverse split, and the option contract was adjusted by CBOE as detailed here:


http://www.cboe.com/framed/PDFframed.aspx?content=/publish/TTStockSM/16-561.pdf§ion=SEC_RESOURCES&title=16-561+IPath+S%26P+500+VIX+Short-Term+Futures+ETN+(%22VXX%22)+1-for-4+Reverse+ETN+Split http://www.cboe.com/framed/PDFframed.aspx?content=/publish/TTStockSM/16-561.pdf§ion=SEC_RESOURCES&title=16-561+IPath+S%26P+500+VIX+Short-Term+Futures+ETN+(%22VXX%22)+1-for-4+Reverse+ETN+Split



Now, when I run the =smfGetOptionQuotes formula, I get an "Error" message.


Is there a fix for these types of option contract adjustments?


Thanks,


Billy


Tue Aug 9, 2016 5:52 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I don't see any contract adjustments on OptionsXPress. Nothing for VXX at
all. I do see some things on a VXX1 web page, but not near enough contracts
to match those in the PDF I looked at. There was a January 2017 item on the
VXX1 page.

If you want that particular item, you could do a workaround of something
like:

=RCHGetTableCell("
https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?ChainType=19&&symbol=VXX1&Page=SSF&lstMarket=0&Range=ALL&AdjNonStdOptions=OFF&lstMonths=15
",5,">VXF17")

But I'm not sure that's what you want.

On Tue, Aug 9, 2016 at 11:14 AM, bkipersztok@
​...wrote:

> I use =smfGetOptionQuotes to pull options prices for various securities.
> One of the securities I've been pulling is VXX.
>
> For example, let's say I have "VXX Jan 2017 74 Call" in cell A2, and in
> another cell, I pull its ask price using =smfGetOptionQuotes(A2,"a",0,"
> OX2").
>
> Today, VXX went ex-dividend on a 1-for-4 reverse split, and the option
> contract was adjusted by CBOE as detailed here:
>
> http://www.cboe.com/framed/PDFframed.aspx?content=/
> publish/TTStockSM/16-561.pdf§ion=SEC_RESOURCES&title=
> 16-561+IPath+S%26P+500+VIX+Short-Term+Futures+ETN+(%
> 22VXX%22)+1-for-4+Reverse+ETN+Split
>
> Now, when I run the =smfGetOptionQuotes formula, I get an "Error" message.
>
> Is there a fix for these types of option contract adjustments?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.23

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)