Rabu, 28 Oktober 2015

[smf_addin] Digest Number 3545

7 Messages

Digest #3545

Messages

Tue Oct 27, 2015 5:18 am (PDT) . Posted by:

"Ron Spruell" hashky

I could see the Open Interest at this OX site, so I was wishing. 

https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?SESSIONID=

From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Monday, October 26, 2015 8:42 PM
Subject: Re: [smf_addin] smfGetOptionQuotes-Example-ITM-OTM-Multiple-Expirations.xls, Open Interest

  I think you've got the behaviors reversed. Here's what I get:

| Ticker | Source | b | i |
| MMM 10/30 2015 $140 Call | OX | 15.05 | 33 |
| MMM 10/30 2015 $140 Put | OX | Invalid Put/Call indicator (must be a C): P | Invalid Put/Call indicator (must be a C): P |
| MMM 10/30 2015 $140 Call | OX2 | 15.05 | Unrecognized item ID: I |
| MMM 10/30 2015 $140 Put | OX2 | 0 | Unrecognized item ID: I |

...which is what I would expect. The "OX" data source is for calls only. I could find no URL for getting directly to greeks for the puts on OptionsXPress. The "OX2" data source doesn't have open interest available.

On Mon, Oct 26, 2015 at 6:08 PM, Ron Spruell hashky@...wrote:

Maybe this is another "Senior Moment".  I am trying to pull Open Interest.  The template will pull Open Interest for Calls by changing Cell D5 to OX.  However, I cannot get Puts Open Interest to work.
I got calls to work by expanding the Array from Column E:Column I to Column E Column J.  I then added "i" to the datacodelist.  Using OX2, the error I get isInvalid Put/Call indicator (must be a C): P
Using OX I get
Unrecognized item Id: I

Any more magic tricks?

#yiv5761131065 -- #yiv5761131065ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5761131065 #yiv5761131065ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5761131065 #yiv5761131065ygrp-mkp #yiv5761131065hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5761131065 #yiv5761131065ygrp-mkp #yiv5761131065ads {margin-bottom:10px;}#yiv5761131065 #yiv5761131065ygrp-mkp .yiv5761131065ad {padding:0 0;}#yiv5761131065 #yiv5761131065ygrp-mkp .yiv5761131065ad p {margin:0;}#yiv5761131065 #yiv5761131065ygrp-mkp .yiv5761131065ad a {color:#0000ff;text-decoration:none;}#yiv5761131065 #yiv5761131065ygrp-sponsor #yiv5761131065ygrp-lc {font-family:Arial;}#yiv5761131065 #yiv5761131065ygrp-sponsor #yiv5761131065ygrp-lc #yiv5761131065hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5761131065 #yiv5761131065ygrp-sponsor #yiv5761131065ygrp-lc .yiv5761131065ad {margin-bottom:10px;padding:0 0;}#yiv5761131065 #yiv5761131065actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5761131065 #yiv5761131065activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5761131065 #yiv5761131065activity span {font-weight:700;}#yiv5761131065 #yiv5761131065activity span:first-child {text-transform:uppercase;}#yiv5761131065 #yiv5761131065activity span a {color:#5085b6;text-decoration:none;}#yiv5761131065 #yiv5761131065activity span span {color:#ff7900;}#yiv5761131065 #yiv5761131065activity span .yiv5761131065underline {text-decoration:underline;}#yiv5761131065 .yiv5761131065attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5761131065 .yiv5761131065attach div a {text-decoration:none;}#yiv5761131065 .yiv5761131065attach img {border:none;padding-right:5px;}#yiv5761131065 .yiv5761131065attach label {display:block;margin-bottom:5px;}#yiv5761131065 .yiv5761131065attach label a {text-decoration:none;}#yiv5761131065 blockquote {margin:0 0 0 4px;}#yiv5761131065 .yiv5761131065bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5761131065 .yiv5761131065bold a {text-decoration:none;}#yiv5761131065 dd.yiv5761131065last p a {font-family:Verdana;font-weight:700;}#yiv5761131065 dd.yiv5761131065last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5761131065 dd.yiv5761131065last p span.yiv5761131065yshortcuts {margin-right:0;}#yiv5761131065 div.yiv5761131065attach-table div div a {text-decoration:none;}#yiv5761131065 div.yiv5761131065attach-table {width:400px;}#yiv5761131065 div.yiv5761131065file-title a, #yiv5761131065 div.yiv5761131065file-title a:active, #yiv5761131065 div.yiv5761131065file-title a:hover, #yiv5761131065 div.yiv5761131065file-title a:visited {text-decoration:none;}#yiv5761131065 div.yiv5761131065photo-title a, #yiv5761131065 div.yiv5761131065photo-title a:active, #yiv5761131065 div.yiv5761131065photo-title a:hover, #yiv5761131065 div.yiv5761131065photo-title a:visited {text-decoration:none;}#yiv5761131065 div#yiv5761131065ygrp-mlmsg #yiv5761131065ygrp-msg p a span.yiv5761131065yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5761131065 .yiv5761131065green {color:#628c2a;}#yiv5761131065 .yiv5761131065MsoNormal {margin:0 0 0 0;}#yiv5761131065 o {font-size:0;}#yiv5761131065 #yiv5761131065photos div {float:left;width:72px;}#yiv5761131065 #yiv5761131065photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5761131065 #yiv5761131065photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5761131065 #yiv5761131065reco-category {font-size:77%;}#yiv5761131065 #yiv5761131065reco-desc {font-size:77%;}#yiv5761131065 .yiv5761131065replbq {margin:4px;}#yiv5761131065 #yiv5761131065ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5761131065 #yiv5761131065ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5761131065 #yiv5761131065ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5761131065 #yiv5761131065ygrp-mlmsg select, #yiv5761131065 input, #yiv5761131065 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5761131065 #yiv5761131065ygrp-mlmsg pre, #yiv5761131065 code {font:115% monospace;}#yiv5761131065 #yiv5761131065ygrp-mlmsg * {line-height:1.22em;}#yiv5761131065 #yiv5761131065ygrp-mlmsg #yiv5761131065logo {padding-bottom:10px;}#yiv5761131065 #yiv5761131065ygrp-msg p a {font-family:Verdana;}#yiv5761131065 #yiv5761131065ygrp-msg p#yiv5761131065attach-count span {color:#1E66AE;font-weight:700;}#yiv5761131065 #yiv5761131065ygrp-reco #yiv5761131065reco-head {color:#ff7900;font-weight:700;}#yiv5761131065 #yiv5761131065ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5761131065 #yiv5761131065ygrp-sponsor #yiv5761131065ov li a {font-size:130%;text-decoration:none;}#yiv5761131065 #yiv5761131065ygrp-sponsor #yiv5761131065ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5761131065 #yiv5761131065ygrp-sponsor #yiv5761131065ov ul {margin:0;padding:0 0 0 8px;}#yiv5761131065 #yiv5761131065ygrp-text {font-family:Georgia;}#yiv5761131065 #yiv5761131065ygrp-text p {margin:0 0 1em 0;}#yiv5761131065 #yiv5761131065ygrp-text tt {font-size:120%;}#yiv5761131065 #yiv5761131065ygrp-vital ul li:last-child {border-right:none !important;}#yiv5761131065

Tue Oct 27, 2015 5:39 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I think that's the OX3 data source?

On Tue, Oct 27, 2015 at 5:16 AM, Ron Spruell hashky@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I could see the Open Interest at this OX site, so I was wishing.
>
> <https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?SESSIONID=>
> https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?SESSIONID=
>
>
>

Tue Oct 27, 2015 7:06 am (PDT) . Posted by:

arasconp

Hello Randy,


Can we get data from morningstar in the addin?


thanks

Tue Oct 27, 2015 11:11 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I do all the time. There are some templates on the web site. If you need
premium items, you have to create the IE security cookie first, using
either IE or the EXCEL Web Query dialog (preferred; keyboard shortcut
alt+d+d+w).

One difficulty with Morningstar is that they create many of their web pages
dynamically, so the data needs to be extracted from the sourced web pages
they used to dynamically create the displayed web page.

On Tue, Oct 27, 2015 at 7:06 AM, arasconp@yahoo.com.mx [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Can we get data from morningstar in the addin?
>
>
>
>

Tue Oct 27, 2015 2:07 pm (PDT) . Posted by:

rogacox

I am looking for historical total return numbers for ETFs and Funds for various lengths of time (YTD, 1 Year, 3 Year, etc.). I can get Yahoo's numbers:

(RCHGetTableCell("http://finance.yahoo.com/q/pm?s=~~~~~+Performance",1,"Year To Date"))

but Morningstar's numbers generate an error message of "#VALUE!",

((RCHGetWebData("http://performance.morningstar.com/funds/etf/total-returns.action?t=~~~~~"),"Trailing Total Returns")

The problem is that the numbers are different. Morningstar appears to agree with MSN. The MSN page for SPY is:

http://www.msn.com/en-us/money/etfdetails/fi-126.1.SPY.ARCX?symbol=SPY&form=PRFISB http://www.msn.com/en-us/money/etfdetails/fi-126.1.SPY.ARCX?symbol=SPY&form=PRFISB

So far I am unable to get the data using the RCHGetWebData for either the Morningstar or MSN pages. I have tried open function displays hoping I could narrow down the exact search if I could get a string returned and find the data in the string. I am using Windows 10. Any help you can give would be appreciated.
Roger


Tue Oct 27, 2015 4:26 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I always use the smfPricesByDates() function and use the adjusted
historical quotes on Yahoo to compute my total returns, because I can do it
for any period I choose.

The reason you have an issue with the MorningStar formula is that the web
page you're using is one that is dynamically generated. That is, they get
the data from someplace else and put it on the web page. However, the
add-in extracts data from the original source code of the web page -- so if
the data isn't there, it can't be extracted.

Note that your Yahoo page is performance as of the end of the previous
month. So, as of 9/29/2015.

Here is an example of the static web page MorningStar uses to create the
dynamic web page:

http://performance.morningstar.com/Performance/etf/trailing-total-returns.action?t=SPY

So, for example, the 1-month return:

=RCHGetTableCell("
http://performance.morningstar.com/Performance/etf/trailing-total-returns.action?t=SPY",3,">Total
Return %","(Price)")

On Tue, Oct 27, 2015 at 2:07 PM, rogacox@... wrote:

>
> I am looking for historical total return numbers for ETFs and Funds for
> various lengths of time (YTD, 1 Year, 3 Year, etc.). I can get Yahoo's
> numbers:
>
> (RCHGetTableCell("http://finance.yahoo.com/q/pm?s=~~~~~+Performance",1,"Year
> To Date"))
>
> but Morningstar's numbers generate an error message of "#VALUE!",
>
> ((RCHGetWebData("
> http://performance.morningstar.com/funds/etf/total-returns.action?t=~~~~~"),"Trailing
> Total Returns")
>
> The problem is that the numbers are different. Morningstar appears to
> agree with MSN. The MSN page for SPY is:
>
>
> http://www.msn.com/en-us/money/etfdetails/fi-126.1.SPY.ARCX?symbol=SPY&form=PRFISB
>
> So far I am unable to get the data using the RCHGetWebData for either the
> Morningstar or MSN pages. I have tried open function displays hoping I
> could narrow down the exact search if I could get a string returned and
> find the data in the string. I am using Windows 10. Any help you can give
> would be appreciated.
>

Wed Oct 28, 2015 12:55 am (PDT) . Posted by:

schlange.meister

I have just downloaded the newest plugin files and just tried to use some ADVfN codes to collect the last 10 years of dividends for a stock. Seems every ADVfn code gives me an error, but Google codes work fine.


Can anyone advise me what is wrong and how to fix it?


Cheers
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.00

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)