|
Title: Need help - Putting API data into a spreadsheet. Post by: ekuuL on December 28, 2017, 02:05:00 AM 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 Title: Re: Need help - Putting API data into a spreadsheet. Post by: ekuuL on December 28, 2017, 07:02:16 AM is there anybody out there ???
Title: Re: Need help - Putting API data into a spreadsheet. Post by: ekuuL on December 28, 2017, 11:17:23 AM PM or post here to discuss further ;D
Title: Re: Need help - Putting API data into a spreadsheet. Post by: DinosaurBit on December 28, 2017, 12:52:27 PM 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! Title: Re: Need help - Putting API data into a spreadsheet. Post by: uditwapt on December 30, 2017, 11:12:35 PM Hi,
Please share more details for this, might be I can you in this same. Regards Uditwapt Title: Re: Need help - Putting API data into a spreadsheet. Post by: PrinceBTC on December 31, 2017, 12:57:30 AM 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/ (https://www.benlcollins.com/apps-script/beginner-apis/) Title: Re: Need help - Putting API data into a spreadsheet. Post by: Jeeps on January 01, 2018, 12:54:33 AM 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 (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 |