Bitcoin Forum
November 23, 2017, 10:13:47 AM *
News: Latest stable version of Bitcoin Core: 0.15.1  [Torrent].
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: Can I import live price data from bittrex to excel?  (Read 1766 times)
cyaadz
Sr. Member
****
Offline Offline

Activity: 252


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

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

Posts: 1511432027

View Profile Personal Message (Offline)

Ignore
1511432027
Reply with quote  #2

1511432027
Report to moderator
1511432027
Hero Member
*
Offline Offline

Posts: 1511432027

View Profile Personal Message (Offline)

Ignore
1511432027
Reply with quote  #2

1511432027
Report to moderator
Join ICO Now A blockchain platform for effective freelancing
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1511432027
Hero Member
*
Offline Offline

Posts: 1511432027

View Profile Personal Message (Offline)

Ignore
1511432027
Reply with quote  #2

1511432027
Report to moderator
1511432027
Hero Member
*
Offline Offline

Posts: 1511432027

View Profile Personal Message (Offline)

Ignore
1511432027
Reply with quote  #2

1511432027
Report to moderator
h0lybyte
Hero Member
*****
Offline Offline

Activity: 588



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!

       ▀
   ▄▄▄   ▄▀
   ███ ▄▄▄▄  ██
       ████
    ▄  ▀▀▀▀
▄▄
      ██    ▀▀
██▄█▄▄▄████████
▄▄▄▄▄▄▄▄▀▀███▀▀▀
██████████████████
████▄▀▄▀▄▀███▀▀▀▀▀
████▄▀▄▀▄▀███ ▀
████▄▀▄▀▄▀████████
▀█████████████████
]
,CoinPayments,
█████
█████ ██
█████ ██
█████ ██
█████ ██
█████ ██
█████ ██
█████ ██
█████ ██
█████ ██
█████ ██
█████ ██
█████
█████
█████ ██
█████ ██
█████ ██
█████ ██
█████ ██
█████ ██
█████ ██
█████ ██
█████ ██
█████ ██
█████ ██
█████
█████
█████ ██
█████ ██
█████ ██
█████ ██
█████ ██
█████ ██
█████ ██
█████ ██
█████ ██
█████ ██
█████ ██
█████
cyaadz
Sr. Member
****
Offline Offline

Activity: 252


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:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!