Bitcoin Forum
July 18, 2018, 03:12:53 PM *
News: Latest stable version of Bitcoin Core: 0.16.1  [Torrent]. (New!)
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: Can I import live price data from bittrex to excel?  (Read 1898 times)
cyaadz
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?
1531926773
Hero Member
*
Offline Offline

Posts: 1531926773

View Profile Personal Message (Offline)

Ignore
1531926773
Reply with quote  #2

1531926773
Report to moderator
1531926773
Hero Member
*
Offline Offline

Posts: 1531926773

View Profile Personal Message (Offline)

Ignore
1531926773
Reply with quote  #2

1531926773
Report to moderator
1531926773
Hero Member
*
Offline Offline

Posts: 1531926773

View Profile Personal Message (Offline)

Ignore
1531926773
Reply with quote  #2

1531926773
Report to moderator
The World's Betting Exchange

Bet with play money. Win real Bitcoin. 5BTC Prize Fund for World Cup 2018.

Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1531926773
Hero Member
*
Offline Offline

Posts: 1531926773

View Profile Personal Message (Offline)

Ignore
1531926773
Reply with quote  #2

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

Activity: 798
Merit: 510



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!

arianee
• • • ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
eSmart-link Connecting Owners, Assets And Brandse
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ • • •
Discord
Telegram ⊐●⊏ Reddit
Twitter ⊐●⊏ Instagram
Medium ⊐●⊏ Linkedin
cyaadz
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:  

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!