Author

Topic: Need help - Putting API data into a spreadsheet. (Read 142 times)

newbie
Activity: 36
Merit: 0
December 31, 2017, 07:54:33 PM
#7
You can use Google Sheets with an Add-On like "Magic JSON".

For example, I quickly created this sheet: https://docs.google.com/spreadsheets/d/15TjWWvj46HNQ101KORtsnWR3xLjZCNyMX2kK1AsIAN0/edit?usp=sharing

Now, I'm not sure if it will update automatically or not (guessing it won't), but you can just re-import using the Magic JSON Add-On when you need/want it updated.

Hope that helps!

Edit: If it was helpful, here's my XRP address Smiley rfFdEnprddrvRP7FnxKeSWkGFfjQ5oXxbq
member
Activity: 103
Merit: 10
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/


newbie
Activity: 10
Merit: 0
Hi,

Please share more details for this, might be I can you in this same.

Regards
Uditwapt
jr. member
Activity: 30
Merit: 17
This is rather simple to develop actually.

If you want it done with Google Spreadsheet, it could refresh automatically at a given frequency (each 15 mins, hourly, etc.).

You would need some server environment (shared hosting would work) to host the process.

I can give a hand, but I'm swamped with work and really just wandering around on the forum because I have some free time during the holidays. Smiley My rate isn't cheap neither; I would charge around 0.010725 BTC for such a project (and host it somewhere on a server of mine for you for 6 months). But just wanted to give you a heads up on this.

You can probably find someone who would be much cheaper on Upwork. Just give the same project description as above and take the cheapest proposal! Be careful with people from India as the quality of their work is generally not that good (I'm talking from experience here; has been using Upwork/vWorker/Rentacoder for more than 10 years). Really just a rule of thumb; I have nothing against them. Wink

Good luck!
newbie
Activity: 19
Merit: 0
PM or post here to discuss further  Grin
newbie
Activity: 19
Merit: 0
is there anybody out there Huh
newbie
Activity: 19
Merit: 0
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
Jump to: