Bitcoin Forum

Economy => Service Discussion => Topic started by: cyaadz on September 29, 2014, 08:54:10 AM



Title: Can I import live price data from bittrex to excel?
Post by: cyaadz on September 29, 2014, 08:54:10 AM
As per topic, is this possible? If so, any idea how to do it?


Title: Re: Can I import live price data from bittrex to excel?
Post by: h0lybyte on September 29, 2014, 10:42:02 PM
You could grab the data (live price data) and then save it as a excel file , called remote_excel ; then setup a cron task to automatically update the remote_excel file then set the cron task based on the timing you want (seconds, mins, hours ect..)

Then use local_excel (where you plan on using the data) to call the remote_excel sheet to get the latest prices.

http://office.microsoft.com/en-us/excel-help/create-an-external-reference-link-to-a-cell-range-in-another-workbook-HP010102338.aspx
^ reference.

Hope that helps!


Title: Re: Can I import live price data from bittrex to excel?
Post by: cyaadz on September 30, 2014, 05:56:49 PM
Thanks for the reply I'll have a look into it, I'm surprised no one else has done this tho