Letting MS excell get market data from exchanges

PollysCracker

newbie

Activity: 59

Merit: 0

Quote from: GideonGono on August 13, 2017, 08:24:30 PM

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

GideonGono

hero member

Activity: 2086

Merit: 501

★Bitvest.io★ Play Plinko or Invest!

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?

EACOM

newbie

Activity: 27

Merit: 0

Quote from: PollysCracker on August 13, 2017, 07:25:53 AM

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.

PollysCracker

newbie

Activity: 59

Merit: 0

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

Activity: 27

Merit: 0

Quote from: PollysCracker on July 11, 2017, 08:04:13 AM

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

Activity: 59

Merit: 0

Quote from: kolloh on July 11, 2017, 08:19:00 AM

Quote from: PollysCracker on July 11, 2017, 08:04:13 AM

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/

PollysCracker

newbie

Activity: 59

Merit: 0

Quote from: iluvpie60 on July 11, 2017, 10:12:41 AM

Quote from: PollysCracker on July 11, 2017, 08:04:13 AM

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

laurenB7742

full member

Activity: 1302

Merit: 129

Vaccinized.. immunity level is full.

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.

iluvpie60

hero member

Activity: 700

Merit: 500

Quote from: PollysCracker on July 11, 2017, 08:04:13 AM

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.

kolloh

legendary

Activity: 1736

Merit: 1023

Quote from: PollysCracker on July 11, 2017, 08:04:13 AM

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.

PollysCracker

newbie

Activity: 59

Merit: 0

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?

Topic: Letting MS excell get market data from exchanges (Read 841 times)