Letting MS excell get market data from exchanges

[PollysCracker]

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?

[kolloh]

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]

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.

[laurenB7742]

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]

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

[PollysCracker]

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]

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]

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]

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]

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]

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 ^^