Selasa, 27 Oktober 2015

[smf_addin] Digest Number 3544

5 Messages

Digest #3544

Messages

Mon Oct 26, 2015 6:11 pm (PDT) . Posted by:

"Ron Spruell" hashky

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

Ron

Mon Oct 26, 2015 6:42 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

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 is
> Invalid Put/Call indicator (must be a C): P
>
> Using OX I get
> Unrecognized item Id: I
>
> Any more magic tricks?
>
>

Mon Oct 26, 2015 9:27 pm (PDT) . Posted by:

wongkayau


Hello Randy,


Good morning.


I would like to download data from this website
http://money.finance.sina.com.cn/corp/go.php/vFD_FootNotes/stockid/002202.phtml

I can successfully download data from it by using smf. However, I cannot download text from it which is in Simplified Chinese Character (GB2312), while my window 8 is using Unicode. All the downloaded texts in excel are in

Mon Oct 26, 2015 11:24 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sorry. Not a clue.

On Mon, Oct 26, 2015 at 9:27 PM, wongkayau@... wrote:

> Hello Randy,
>
> Good morning.
>
> I would like to download data from this website
>
> http://money.finance.sina.com.cn/corp/go.php/vFD_FootNotes/stockid/002202.phtml
>
> I can successfully download data from it by using smf. However, I cannot
> download text from it which is in Simplified Chinese Character (GB2312),
> while my window 8 is using Unicode. All the downloaded texts in excel are
> in
> ������.
>
> Do you know how might I download the text? I tried changing window
> default language but no luck.
>
>
>

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

wongkayau

Hi Randy,


No problem. Thanks a lot.


Wish you have a great day.


Cheers,
Laurent

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar