2 Messages
Digest #4343
Messages
Wed Jun 13, 2018 9:20 pm (PDT) . Posted by:
yvrflyguy
Hi Randy,
I'd like to extract either specific data or the entire table from the Barcharts Most Active Options webpage.
https://www.barchart.com/options/most-active?page=all https://www.barchart.com/options/most-active?page=all
It appears that the table is dynamically built using a json call.
Is there a method for doing this with an smf function?
Alternatively, there is a csv download link for those with a Barcharts.com account, which I have. Is there any method for automating the download of this csv table into excel?
Thanks for any advice you can provide.
Peter
I'd like to extract either specific data or the entire table from the Barcharts Most Active Options webpage.
https://www.barchart.com/options/most-active?page=all https://www.barchart.com/options/most-active?page=all
It appears that the table is dynamically built using a json call.
Is there a method for doing this with an smf function?
Alternatively, there is a csv download link for those with a Barcharts.com account, which I have. Is there any method for automating the download of this csv table into excel?
Thanks for any advice you can provide.
Peter
Thu Jun 14, 2018 12:52 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Let me take a look at it. The Barchart API just uses a "&list=" parameter
instead of the normal "&symbols=" parameter. I know of a handful of such
"&list" items. I think a (minor?) change to the
smfGetBarchartPortfolioView() function could process the "&list=" output.
For example, this is the API call that gets the JSON file:
https://core-api.barchart.com/v1/quotes/get?list=options.mostActive.us&fields=symbol%2ClastPrice%2CpriceChange%2CpercentChange%2CopenPrice%2ChighPrice%2ClowPrice%2Cvolume%2CtradeTime%2CdividendExDate%2Cdividend%2CnextEarningsDate%2CweightedAlpha%2CsymbolCode%2CsymbolType%2ChasOptions&meta=field.shortName%2Cfield.type%2Cfield.description&hasOptions=true&raw=1
On Wed, Jun 13, 2018 at 9:19 PM, a330pete@
...
wrote:
> I'd like to extract either specific data or the entire table from the
> Barcharts Most Active Options webpage.
>
> https://www.barchart.com/options/most-active?page=all
>
> It appears that the table is dynamically built using a json call.
>
> Is there a method for doing this with an smf function?
>
> Alternatively, there is a csv download link for those with a Barcharts..com
> account, which I have. Is there any method for automating the download of
> this csv table into excel?
>
>
>
instead of the normal "&symbols=" parameter. I know of a handful of such
"&list" items. I think a (minor?) change to the
smfGetBarchartPortfolioView() function could process the "&list=" output.
For example, this is the API call that gets the JSON file:
https://core-api.barchart.com/v1/quotes/get?list=options.mostActive.us&fields=symbol%2ClastPrice%2CpriceChange%2CpercentChange%2CopenPrice%2ChighPrice%2ClowPrice%2Cvolume%2CtradeTime%2CdividendExDate%2Cdividend%2CnextEarningsDate%2CweightedAlpha%2CsymbolCode%2CsymbolType%2ChasOptions&meta=field.shortName%2Cfield.type%2Cfield.description&hasOptions=true&raw=1
On Wed, Jun 13, 2018 at 9:19 PM, a330pete@
...
wrote:
> I'd like to extract either specific data or the entire table from the
> Barcharts Most Active Options webpage.
>
> https://www.barchart.com/options/most-active?page=all
>
> It appears that the table is dynamically built using a json call.
>
> Is there a method for doing this with an smf function?
>
> Alternatively, there is a csv download link for those with a Barcharts..com
> account, which I have. Is there any method for automating the download of
> this csv table into excel?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar