Bitcoin Forum
June 22, 2024, 04:18:48 PM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Can I import live price data from bittrex to excel?  (Read 1960 times)
cyaadz (OP)
Sr. Member
****
Offline Offline

Activity: 252
Merit: 250


View Profile
September 29, 2014, 08:54:10 AM
 #1

As per topic, is this possible? If so, any idea how to do it?
h0lybyte
Hero Member
*****
Offline Offline

Activity: 924
Merit: 511


View Profile
September 29, 2014, 10:42:02 PM
 #2

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!
cyaadz (OP)
Sr. Member
****
Offline Offline

Activity: 252
Merit: 250


View Profile
September 30, 2014, 05:56:49 PM
 #3

Thanks for the reply I'll have a look into it, I'm surprised no one else has done this tho
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!