Senin, 12 Januari 2015

[smf_addin] Digest Number 3294

2 Messages

Digest #3294

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.

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.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar