Bitcoin Forum
November 17, 2018, 05:29:52 AM *
News: Latest Bitcoin Core release: 0.17.0 [Torrent].
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Letting MS excell get market data from exchanges  (Read 719 times)
PollysCracker
Newbie
*
Offline Offline

Activity: 59
Merit: 0


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?

1542432592
Hero Member
*
Offline Offline

Posts: 1542432592

View Profile Personal Message (Offline)

Ignore
1542432592
Reply with quote  #2

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

Posts: 1542432592

View Profile Personal Message (Offline)

Ignore
1542432592
Reply with quote  #2

1542432592
Report to moderator
1542432592
Hero Member
*
Offline Offline

Posts: 1542432592

View Profile Personal Message (Offline)

Ignore
1542432592
Reply with quote  #2

1542432592
Report to moderator
kolloh
Legendary
*
Offline Offline

Activity: 1330
Merit: 1000


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: 672
Merit: 500



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: 336
Merit: 107



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.
PollysCracker
Newbie
*
Offline Offline

Activity: 59
Merit: 0


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
Newbie
*
Offline Offline

Activity: 59
Merit: 0


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: 27
Merit: 0


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
Newbie
*
Offline Offline

Activity: 59
Merit: 0


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: 27
Merit: 0


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: 896
Merit: 500



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?

           ▄▄███████████▄▄▄
        ███            ▀▀█████▄
      ██                   ▀█████▄
    ██                       ▀█████
   █          ██  ██           █████
  █           ██  ██            █████
 █        ▄▄███████████          █████
 █        █████████████           ████▌
█         █████                   █████
█         █████                   █▀ ▀█
█         ████████████              ▄ 
█         ████████████            ▄███▄
█         █████                   █████
 █        █████                   ████▌
 █        █████████████          █████
  █       ▀▀███████████         █████
   █▄         ██  ██          ▄████▀
    ▀█        ██  ██        ▄████▀
      ▀█▄                 ▄████▀
         ▀▀█▄▄▄▄▄▄▄▄▄▄▄███▀▀▀
██
██  ██  ██
██
██  ██  ██
██  ██  ██
██  ██  ██
██  ██  ██
██  ██  ██
██  ██  ██
██  ██  ██
██
██  ██  ██
██
██
██  ██  ██
██
██  ██  ██
██  ██  ██
██  ██  ██
██  ██  ██
██  ██  ██
██  ██  ██
██  ██  ██
██
██  ██  ██
██
▄███▄
███████████████████████
██                   ██
██ ░███████████████░ ██
██                   ██
▀███ ░███████████████░ ███▀
▄  ▀█                   █▀  ▄
██▄    ███████████████    ▄██
████▄                   ▄████
██████▄               ▄██████
████████             ████████
██████▀  ▄██▄   ▄██▄  ▀██████
████▀  ▄██████▄██████▄  ▀████
██▀  ▄█████████████████▄  ▀██

WHITEPAPER
.▒██████████████████████▒
▒████████████████████████▒
▒████████████████████████▒
▒██▄     ███████     ▄███▒
▒████     █████     █████▒
▒████ ▌    ███▌     █████▒
▒████ █     █▌ ▐    █████▒
▒████ ██      ▐█    █████▒
▒████ ███    ▐██    █████▒
▒███▀ ▀███   ███    █████▒
▒█▀     ▀██ ██▀      ▀███▒
▒████████████████████████▒
.▒██████████████████████▒
.▒██████████████████████▒
▒████████████████████████▒
▒█████████████▀    ▀█████▒
▒██░▀████████▌      ▀████▒
▒██░   ▀████▀        ▀███▒
▒██                 █████▒
▒███                █████▒
▒█████              █████▒
▒██████           ▄██████▒
▒█████▀         ▄████████▒
▒███▄▄      ▄▄███████████▒
▒████████████████████████▒
 ▒██████████████████████▒
.▒██████████████████████▒
▒████████████████████████▒
▒████████████████████████▒
▒████████████▀▀    ▓█████▒
▒███████▀▀     ▄▀  ▓█████▒
▒███▀▀       ▄▀    ██████▒
▒██░       ▄▀░░    ██████▒
▒████▄▄  ▄▀       ███████▒
▒████████▄░       ███████▒
▒█████████        ███████▒
▒██████████ ██▄▄ ████████▒
▒████████████████████████▒
 ▒██████████████████████▒
PollysCracker
Newbie
*
Offline Offline

Activity: 59
Merit: 0


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!