Bitcoin Forum
December 16, 2017, 01:37:54 PM *
News: Latest stable version of Bitcoin Core: 0.15.1  [Torrent].
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: Letting MS excell get market data from exchanges  (Read 703 times)
PollysCracker
Jr. Member
*
Offline Offline

Activity: 59


View Profile
July 11, 2017, 01:04:13 PM
 #1

Hello,

I was wondering if it is possible to get MS Excel to interact with an exchange such as bittrex or poloniex using my accounts API key.

I would want to bring in the realtime vallue's of certain cryptocurrencies/assets into excel without manually having to enter them all in there each time i wanna do a check,
anyone know if and how this is possible?

1513431474
Hero Member
*
Offline Offline

Posts: 1513431474

View Profile Personal Message (Offline)

Ignore
1513431474
Reply with quote  #2

1513431474
Report to moderator
1513431474
Hero Member
*
Offline Offline

Posts: 1513431474

View Profile Personal Message (Offline)

Ignore
1513431474
Reply with quote  #2

1513431474
Report to moderator
1513431474
Hero Member
*
Offline Offline

Posts: 1513431474

View Profile Personal Message (Offline)

Ignore
1513431474
Reply with quote  #2

1513431474
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
kolloh
Legendary
*
Offline Offline

Activity: 1176


View Profile
July 11, 2017, 01:19:00 PM
 #2

Hello,

I was wondering if it is possible to get MS Excel to interact with an exchange such as bittrex or poloniex using my accounts API key.

I would want to bring in the realtime vallue's of certain cryptocurrencies/assets into excel without manually having to enter them all in there each time i wanna do a check,
anyone know if and how this is possible?



I'm not sure if Excel supports something like this, but you should be able to at least use the API to grab the values and then write a script to place them in a CSV file which could be imported to Excel. You would of course need some programming experience or know/hire someone to code it for you.
iluvpie60
Hero Member
*****
Offline Offline

Activity: 658



View Profile
July 11, 2017, 03:12:41 PM
 #3

Hello,

I was wondering if it is possible to get MS Excel to interact with an exchange such as bittrex or poloniex using my accounts API key.

I would want to bring in the realtime vallue's of certain cryptocurrencies/assets into excel without manually having to enter them all in there each time i wanna do a check,
anyone know if and how this is possible?



Excel should have the functionality of importing data from a website. Open up Excel and click on the Data tab, clck on the buttom that says "From Web". You should be able to  navigate to the site you want to get data from(assuming it is open and lets you capture it).

Check out some guides on doing this on youtube, but it should work for most of the exchanges and most sites.



                                         ▄
                 ▄▄████████▄▄         ▄▄██
 ▄▄           ▄██▀▀        ▀▀██▄    ▄███▀
 ▀███▄▄     ▄█▀                ▀█▄▄█████▀
  ▀██████▄▄█▀                ▄▄███████▀
   ▐█████████▄           ▄▄███████████
     ▀█████████▄▄      ▄█████████████
       ▀██████████    ███████████████
        ▐▀█████████  █████████████▀ ▐▌
        ▐▌ ▀▀██████ ▐███████████▀   ▐▌
        ▐▌      ▀██ ▐█████████▀     ▐▌
         █        ▀  ██████         █
         ▐█          ▐█████▄       █▌
          ▀█▄         ▀██████▄   ▄█▀
            ▀█▄         ▀█████▌▄█▀
              ▀██▄▄       ▀▄▄██▀
                ▀▀████████▀▀
T
....ANGEL TOKEN....


                                         ▄
                 ▄▄████████▄▄         ▄▄██
 ▄▄           ▄██▀▀        ▀▀██▄    ▄█▀█▀ 
 ▀█▀█▄▄     ▄█▀                ▀█▄▄█  ▄█▀ 
  ▀█  ▀▀█▄▄█▀                ▄▄██░   █▀   
   ▐▄▄  ░░░▀█▄           ▄▄█▀▀░░░   ▄█     
     ▀█▄ ░░░▒▒█▄▄      ▄██▒▒▒▒▒░    █     
       ▀▄▄ ░░▒▒▒▓█    ██▒▒▒▒▒▒░   ▄▄█     
        ▐▀█▄░░▒▒▓██  █▓▒▒▒▒▒▒░  ▄█▀ ▐▌     
        ▐▌ ▀▀█▒▓███░▐█▓▒▒▒▒░░ ▄█▀   ▐▌     
        ▐▌      ▀██ ▐█▓▓▒▒▄▄▄█▀     ▐▌     
         █        ▀  █▓█▀▀█         █     
         ▐█          ▐▄▓░ █▄       █▌     
          ▀█▄         ▀█▒░ ▀█▄   ▄█▀       
            ▀█▄         ▀█▄▄▄█▌▄█▀         
              ▀██▄▄       ▀▄▄██▀           
                 ▀▀████████▀▀             

laurenB7742
Full Member
***
Offline Offline

Activity: 168



View Profile
July 11, 2017, 03:49:50 PM
 #4

It's a little wonky to use but check out Import.IO to scrape the data offline. I'm a huge fan of this software and have used it to scrape data just like exchange data offline before.

❘|❘ NEUFUND — Re-Imagine ICOs | Connect off- and on-chain with equity tokens | Enjoy risk-free commitment ❘|❘
JOIN THE ICBM | JOIN THE DISCUSSION
PollysCracker
Jr. Member
*
Offline Offline

Activity: 59


View Profile
July 11, 2017, 09:27:38 PM
 #5

Hello,

I was wondering if it is possible to get MS Excel to interact with an exchange such as bittrex or poloniex using my accounts API key.

I would want to bring in the realtime vallue's of certain cryptocurrencies/assets into excel without manually having to enter them all in there each time i wanna do a check,
anyone know if and how this is possible?



Excel should have the functionality of importing data from a website. Open up Excel and click on the Data tab, clck on the buttom that says "From Web". You should be able to  navigate to the site you want to get data from(assuming it is open and lets you capture it).

Check out some guides on doing this on youtube, but it should work for most of the exchanges and most sites.

Thanks, i just tried it and unfortunatly it doesnt work on bittrex and poloniex, that would have done the trick though...
Back to the drawing board Smiley
PollysCracker
Jr. Member
*
Offline Offline

Activity: 59


View Profile
July 11, 2017, 10:36:59 PM
 #6

Hello,

I was wondering if it is possible to get MS Excel to interact with an exchange such as bittrex or poloniex using my accounts API key.

I would want to bring in the realtime vallue's of certain cryptocurrencies/assets into excel without manually having to enter them all in there each time i wanna do a check,
anyone know if and how this is possible?



I'm not sure if Excel supports something like this, but you should be able to at least use the API to grab the values and then write a script to place them in a CSV file which could be imported to Excel. You would of course need some programming experience or know/hire someone to code it for you.

Combining this with what iluvpie60 recommended, i managed to use the Public api from coinmarketcap to fetch the required data, but the problem i have now is that when i combine this with public api ticker, is that it auomaticly downloads the returned response in a json file. so i'm stuck here for now..

So now i have the data i want in a json file, now i need to get that json file into Excel and make it automaticly refresh every minute or so(redownloading the json -> import into excel automaticly)

This has helped me alot so far, but now i'm stuck for now: https://www.reddit.com/r/ethtrader/comments/6b16fk/how_to_import_coinmarketcap_data_into_excel_and/
looks like i need excel 2016 or powerquery installed for excel 2013, cant install anything on this pc...

BTW im also open for the google spreadsheet option
edit: soem info for spreadsheet: https://www.reddit.com/r/ethtrader/comments/60jofq/import_price_on_bittrex_in_a_google_sheet/
EACOM
Newbie
*
Offline Offline

Activity: 26


View Profile
August 12, 2017, 04:32:10 AM
 #7

Hello,

I was wondering if it is possible to get MS Excel to interact with an exchange such as bittrex or poloniex using my accounts API key.

I would want to bring in the realtime vallue's of certain cryptocurrencies/assets into excel without manually having to enter them all in there each time i wanna do a check,
anyone know if and how this is possible?



Polly,  Am curious how you would use this data setup scenario.

You do realize that the real time value of a crypto and that cryptos' price in one exchange are  often two separate things? There's  a lot of variables at play like trading volume, exchange pricing and policy that influences what each exchange quotes. Also if you are getting minute by minute updates, you risk falling behind the movements with that lag time if on a terminal trading.
PollysCracker
Jr. Member
*
Offline Offline

Activity: 59


View Profile
August 13, 2017, 12:25:53 PM
 #8

This is just to keep track and update my portfolio vallue with ease.

it does the trick, i use the api of bittrex, poloniex and coinmarketcap
EACOM
Newbie
*
Offline Offline

Activity: 26


View Profile
August 13, 2017, 11:22:29 PM
 #9

This is just to keep track and update my portfolio vallue with ease.

it does the trick, i use the api of bittrex, poloniex and coinmarketcap

Fair enough.  I guess thats the beauty of the open ledger. Data integration from different sources becomes a breeze.
Wish all FINTECH was as efficient as that without all those artificial walls.
GideonGono
Hero Member
*****
Offline Offline

Activity: 674



View Profile
August 14, 2017, 01:24:30 AM
 #10

Sorry to be blunt. Why don't you just use any portfolio tracker like blockfolio in mobile or some websited who offer this services? It is much easier and less hassle. These portfolio trackers almost (if not all) track major exchangers like poloniex and bittrex you say?

PollysCracker
Jr. Member
*
Offline Offline

Activity: 59


View Profile
August 14, 2017, 03:03:25 PM
 #11

Sorry to be blunt. Why don't you just use any portfolio tracker like blockfolio in mobile or some websited who offer this services? It is much easier and less hassle. These portfolio trackers almost (if not all) track major exchangers like poloniex and bittrex you say?

Well i wanted to be able to make my own creation, having the ability to ad whatever function i need, the design i want, and the freedom of choice that comes with all of it.
Blockfolio might be ok but with my version now i have a clear view on what profits i have in bitcoin vallue and dollar vallue as it is very important not to confuse these 2, i dont know if blockfolio has that or not, but idc really.

I'm glad with what i made, also gives a satisfaction so win win basicly for me ^^
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!