2 Messages
Digest #3294
1b
Re: Getting Open Interests text download file from www.theocc.com by "Randy Harmelink" rharmelink
Messages
Sun Jan 11, 2015 8:30 pm (PST) . Posted by:
c.kung
Hello,
I am having trouble getting the Options Open Interests text file from the below theocc,com websit:
"http://www.theocc.com/webapps/series-search?symbolType=U&symbol=JPM"
Since the downloaded file is not in the CSV format, I am having trouble of using
smfGetCSVFile to convert the text file into the correct Excel format. Please help.
An alternate way is to use the below URL:
"http://www.optionsclearing.com/webapps/series-search"
and enter symbol of your choice (in my case: JPM) and get the right web page for Open Interests for all series. From there, I would need some help to get the page into Excel.
Thanks.
I am having trouble getting the Options Open Interests text file from the below theocc,com websit:
"http://www.theocc.com/webapps/series-search?symbolType=U&symbol=JPM"
Since the downloaded file is not in the CSV format, I am having trouble of using
smfGetCSVFile to convert the text file into the correct Excel format. Please help.
An alternate way is to use the below URL:
"http://www.optionsclearing.com/webapps/series-search"
and enter symbol of your choice (in my case: JPM) and get the right web page for Open Interests for all series. From there, I would need some help to get the page into Excel.
Thanks.
Sun Jan 11, 2015 8:42 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
It looks like a tab-delimited file, so you can tell smfGetCSVFile() to use
the tab character as the delimiter. For example:
=smfGetCSVFile("
http://www.theocc.com/webapps/series-search?symbolType=U&symbol=JPM
",CHAR(9))
On Sun, Jan 11, 2015 at 8:59 PM, c.kung@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I am having trouble getting the Options Open Interests text file from
> the below theocc,com websit:
>
> "http://www.theocc.com/webapps/series-search?symbolType=*U*&symbol=*JPM"*
>
> Since the downloaded file is not in the CSV format, I am having trouble of
> using
>
> smfGetCSVFile to convert the text file into the correct Excel format.
> Please help.
>
> An alternate way is to use the below URL:
>
> "http://www.optionsclearing.com/webapps/series-search"
>
> and enter symbol of your choice (in my case: JPM) and get the right web
> page for Open Interests for all series. From there, I would need some help
> to get the page into Excel.
>
the tab character as the delimiter. For example:
=smfGetCSVFile("
http://www.theocc.com/webapps/series-search?symbolType=U&symbol=JPM
",CHAR(9))
On Sun, Jan 11, 2015 at 8:59 PM, c.kung@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I am having trouble getting the Options Open Interests text file from
> the below theocc,com websit:
>
> "http://www.theocc.com/webapps/series-search?symbolType=*U*&symbol=*JPM"*
>
> Since the downloaded file is not in the CSV format, I am having trouble of
> using
>
> smfGetCSVFile to convert the text file into the correct Excel format.
> Please help.
>
> An alternate way is to use the below URL:
>
> "http://www.optionsclearing.com/webapps/series-search"
>
> and enter symbol of your choice (in my case: JPM) and get the right web
> page for Open Interests for all series. From there, I would need some help
> to get the page into Excel.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar