I'm not sure what you want to create. Exchanges can provide you with an API so that you can pull information into your own system.
For example, if you want to control current value of your crypto assets on Excel, you can:
1. Create a sheet where you download current value for all cryptocurrencies.
To do this:
a) Create a Query (New Query -> From Other Souces-> From Web).
b) Provide a URL such as "
https://api.coinmarketcap.com/v1/ticker/?convert=EUR&limit=0" to define the Query.
c) A Query editor will appear with a lists of rows labeled "Record". Choose the "Convert to Table" button.
d) Click on the double headed button next to Column1 to display all column names included in the record and press ok + Close and Load.
A new Tab should at his point have been created with current values from exchange API (coinmarketcap).
2. If you want to keep track of your own specific crypto values, you can now create a second Tab with your crypto name and acronimum, and use the Vlookup function to search for the current value of your crypto and multiply that by the amount you have.
3. All you have to do is refresh your data Tab everytime you want a current update on your crypto value.
P.D. The above is how it's done on excel 2016.
