5 Messages
Digest #3544
1b
Re: smfGetOptionQuotes-Example-ITM-OTM-Multiple-Expirations.xls, Ope by "Randy Harmelink" rharmelink
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
Maybe this is another "Senior Moment"
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?
>
>
*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"
> 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.
>
>
>
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
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:
Posting Komentar