Post
Topic
Board Services
Re: Need help - Putting API data into a spreadsheet.
by
PrinceBTC
on 31/12/2017, 00:57:30 UTC
Hi all Smiley

(BTW, I have limited knowledge of coding but am keen too learn if required).

I need help with getting the data from "https://poloniex.com/public?command=returnTicker" to be displayed in a spreadsheet (Excel or Google Sheets).
If possible I would like this this too be automatically updating or able to be refreshed at the click of a button.

If anyone can point me in the right direction that would be great.

Thanks

p.s. can tip in BTC/ripple

Im thinking of SHEETSU service..

Are you willing to pay a monthly subscription?

If not, you can just try SHEETSU for a 2-week free trial..

check them out on https://sheetsu.com Smiley

OR

you can have a look and search for "Google Apps Script" -  it can retrieve data from a third-party API (like the poloniex API) using Google Apps Script and to display it in your Google Sheet. Smiley here is the sample guide: https://www.benlcollins.com/apps-script/beginner-apis/