Need help - Putting API data into a spreadsheet.

[ekuuL]

Hi all

(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

[1714881863]

1714881863

[1714881863]

1714881863

[1714881863]

1714881863

[1714881863]

1714881863

[1714881863]

1714881863

[1714881863]

1714881863

[ekuuL]

is there anybody out there

[ekuuL]

PM or post here to discuss further 

[DinosaurBit]

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. 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.

Good luck!

[uditwapt]

Hi,

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

Regards
Uditwapt

[PrinceBTC]

Hi all

(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

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. here is the sample guide: https://www.benlcollins.com/apps-script/beginner-apis/

[Jeeps]

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 rfFdEnprddrvRP7FnxKeSWkGFfjQ5oXxbq