Bitcoin Forum
September 22, 2017, 10:05:18 AM *
News: Latest stable version of Bitcoin Core: 0.15.0.1  [Torrent]. (New!)
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: Bitcoin markets integration with Excel  (Read 5404 times)
dextryn
Full Member
***
Offline Offline

Activity: 198



View Profile
June 20, 2012, 07:55:55 PM
 #1

So this may be a very simple question to some but I'm a little lost at the moment.  I'm just trying to make an excel sheet where certain cells pull the actual exchange rates in real time so I can have all the information at my fingertips.  Is this sort of thing possible?  Would Google docs work better?
          ▄█████▄
        ▄█████████▄
      ▄████▀   ▀████▄
    ▄████▀   ▄ ▄█▀████▄
  ▄████▀   ▄███▀   ▀████▄
▄████▀   ▄███▀   ▄   ▀████▄
█████   ███▀   ▄███   █████
▀████▄   ▀██▄▄███▀   ▄████▀
  ▀████▄   ▀███▀   ▄████▀
    ▀████▄       ▄████▀
      ▀████▄   ▄████▀
        ▀███  ████▀
          ▀█▄███▀
.
|
.
|
          ▄█████▄
        ▄█████████▄
      ▄████▀   ▀████▄
    ▄████▀   ▄ ▄█▀████▄
  ▄████▀   ▄███▀   ▀████▄
▄████▀   ▄███▀   ▄   ▀████▄
█████   ███▀   ▄███   █████
▀████▄   ▀██▄▄███▀   ▄████▀
  ▀████▄   ▀███▀   ▄████▀
    ▀████▄       ▄████▀
      ▀████▄   ▄████▀
        ▀███  ████▀
          ▀█▄███▀
unthy
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1506074718
Hero Member
*
Offline Offline

Posts: 1506074718

View Profile Personal Message (Offline)

Ignore
1506074718
Reply with quote  #2

1506074718
Report to moderator
1506074718
Hero Member
*
Offline Offline

Posts: 1506074718

View Profile Personal Message (Offline)

Ignore
1506074718
Reply with quote  #2

1506074718
Report to moderator
gweedo
Legendary
*
Offline Offline

Activity: 1246


Java, PHP, HTML/CSS Programmer for Hire!


View Profile WWW
June 20, 2012, 07:59:18 PM
 #2

https://github.com/znort987/glbse-googledoc-macro

Google docs would be the better

Want to earn 2500 SATOSHIS per hour? Come Chat and Chill in https://goseemybits.com/lobby
dextryn
Full Member
***
Offline Offline

Activity: 198



View Profile
June 20, 2012, 08:03:16 PM
 #3

Thanks a ton!
David Rabahy
Hero Member
*****
Offline Offline

Activity: 704



View Profile
September 12, 2013, 05:01:14 PM
 #4

position active on empty cell
Data -> Get External Data From Web -> Address http://bitcoincharts.com/ -> Go (click No if the Script Error popup appears) -> scroll down and click yellow boxed black pointer on Market table -> Import -> Existing worksheet -> OK
David Rabahy
Hero Member
*****
Offline Offline

Activity: 704



View Profile
September 12, 2013, 05:10:10 PM
 #5

Since bitcoincharts is lagging badly;

position active on empty cell
Data -> Get External Data From Web -> Address https://www.bitstamp.net/ -> Go (click Yes if Security Warning popup appears; click No if the Script Error popup appears) -> click yellow boxed black pointer -> Import -> Existing worksheet -> OK
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!