2 Messages
Digest #4296
Messages
Mon Jan 22, 2018 3:04 pm (PST) . Posted by:
navelhunt
Hi Randy,
I am trying to figure out if there is a specific way to parse the data that is provided via API services on www.cryptowat.ch http://www.cryptowat.ch.
Particularly, one can get all crypto price data through https://api.cryptowat.ch/markets/summaries https://api.cryptowat.ch/markets/summaries as you can see.
I have tried to use the function smfgetCSVfile which i can use to get all the data in an excel, but i dont know how to correctly parse it so that in excel we can get the various elements in columns and the rows represent the tickers/markets.
Any guidance to which function or which delimiters to use would be greatly appreciated!
Many thanks!
I am trying to figure out if there is a specific way to parse the data that is provided via API services on www.cryptowat.ch http://www.cryptowat.ch.
Particularly, one can get all crypto price data through https://api.cryptowat.ch/markets/summaries https://api.cryptowat.ch/markets/summaries as you can see.
I have tried to use the function smfgetCSVfile which i can use to get all the data in an excel, but i dont know how to correctly parse it so that in excel we can get the various elements in columns and the rows represent the tickers/markets.
Any guidance to which function or which delimiters to use would be greatly appreciated!
Many thanks!
Mon Jan 22, 2018 4:59 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You'd need to manually extract the data from the JSON file with something
like:
=smfStrExtr(RCHGetWebData("https://api.cryptowat.ch/markets/summaries
","bitfinex:avtbtc",300),"last"":",",",1)
On Mon, Jan 22, 2018 at 4:04 PM, navelhunt@
...
wrote:
> I am trying to figure out if there is a specific way to parse the data
> that is provided via API services on www.cryptowat.ch.
>
> Particularly, one can get all crypto price data through
> https://api.cryptowat.ch/markets/summaries as you can see.
>
> I have tried to use the function smfgetCSVfile which i can use to get all
> the data in an excel, but i dont know how to correctly parse it so that in
> excel we can get the various elements in columns and the rows represent the
> tickers/markets.
>
> Any guidance to which function or which delimiters to use would be greatly
> appreciated!
>
>
>
like:
=smfStrExtr(RCHGetWebData("https://api.cryptowat.ch/markets/summaries
","bitfinex:avtbtc",300),"last"":",",",1)
On Mon, Jan 22, 2018 at 4:04 PM, navelhunt@
...
wrote:
> I am trying to figure out if there is a specific way to parse the data
> that is provided via API services on www.cryptowat.ch.
>
> Particularly, one can get all crypto price data through
> https://api.cryptowat.ch/markets/summaries as you can see.
>
> I have tried to use the function smfgetCSVfile which i can use to get all
> the data in an excel, but i dont know how to correctly parse it so that in
> excel we can get the various elements in columns and the rows represent the
> tickers/markets.
>
> Any guidance to which function or which delimiters to use would be greatly
> appreciated!
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar