> SHARING MY EXCEL TOOL < ( °. ° <) FOLLOW YOUR INVESTMENTS in LIVE - Auto Update currencies prices
[EN]
![excel.png](https://steemitimages.com/DQmafnEMCp7WgtrUxZb9iDCgWimoWxDncWM31WGdcH8ynCK/excel.png)
[FR]
![divider.jpg](https://steemitimages.com/640x0/https://steemitimages.com/DQmVkpTxffNtS82kKoQUcGzWeNzd2U7Rqvu4SzC8BJQP37J/divider.jpg)
[EN]
It is a very simple Excel file consisting of two sheets
The second in the background, collects on the web the value and evolution (24h) of the first 300 crypto-currencies and updates them every 15 minutes.
The first refines and makes usable these harvested data, then combines them in formulas in order to follow the investments made on currencies.
[FR]
C'est un fichier Excel très simple composé de deux feuilles
La seconde en arrière plan, récolte sur le web la valeur ainsi que l'évolution (24h) des 300 premières crypto-monnaies et les met à jour toutes les 15 minutes.
la première épure et rend exploitables ces données récoltées, puis les combine dans des formules afin de suivre les investissements réalisés.
![divider.jpg](https://steemitimages.com/DQmVkpTxffNtS82kKoQUcGzWeNzd2U7Rqvu4SzC8BJQP37J/divider.jpg)
[EN]
You can change my list and choose your currencies to follow in the yellow boxes at the top right. Once your currencies are chosen, you can do as I do and add a hypertext link on the name, allowing you to 1 click go to your favorite exchange chart to watch it in real time on website.
Just below you can also follow the evolution of your investments by filling in the yellow boxes. Finally you can also personalize the small "Memo" rectangle on the right, with your most used addresses or your portfolio addresses to facilitate your exchanges.
![chart.jpg](https://steemitimages.com/640x0/https://steemitimages.com/DQmQiu1rShCzVkLFUfUNJgWf6dWoP2mNpjdkqKGLJEBNykP/chart.jpg)
[FR]
Vous pouvez changer ma liste et choisir vos monnaies à suivre dans les cases jaunes en haut à droite. Une fois vos monnaies choisies, vous pouvez faire comme moi et ajouter un lien hypertext sur le nom, permettant de vous rendre en 1 clic sur le graphique en temps réel de votre site d'échange préféré.
Juste dessous vous pouvez également suivre l'évolution de vos investissements en remplissant les cases jaunes. Enfin, vous pouvez aussi agrémenter le petit "Memo" sur la droite avec vos adresses de site web les plus utilisées ou vos adresses de wallet / portefeuille pour faciliter vos échanges.
![divider.jpg](https://steemitimages.com/DQmVkpTxffNtS82kKoQUcGzWeNzd2U7Rqvu4SzC8BJQP37J/divider.jpg)
[EN]
I created this tool to collect and track on a single screen and in real time the currencies in which I invested, while being able to quickly go on the charts of these or rapidly find my wallet address during a transfer.
I hope it will be as useful as it is to me, do not hesitate to give me feedback, ask me questions if necessary, propose me improvements and to share it, it's free !
![free.png](https://steemitimages.com/640x0/https://steemitimages.com/DQmaj3Yo7DeKMpPvDyfXvyog6LdLVXYdFqVAEUP1sWcReAr/free.png)
[FR]
J'ai créé cet outil pour rassembler et suivre sur un seul écran et en temps réel les monnaies dans lesquelles j'ai investis, tout en pouvant rapidement me rendre sur les graphiques de ces dernières ou bien trouver promptement mon adresse de wallet lors d'un transfert.
J'espère qu'il vous sera aussi utile qu'il l'est pour moi, n'hésitez pas à me faire des retours, me poser des questions si besoin, me proposer des améliorations et à le partager, c'est gratuit !
![divider.jpg](https://steemitimages.com/DQmVkpTxffNtS82kKoQUcGzWeNzd2U7Rqvu4SzC8BJQP37J/divider.jpg)
![donwload.png](https://steemitimages.com/640x0/https://steemitimages.com/DQmasU8GiYEujuPRQzEw1ZvfMCYxrUoq38wMPrWYQXKYAhv/donwload.png)
![divider.jpg](https://steemitimages.com/DQmVkpTxffNtS82kKoQUcGzWeNzd2U7Rqvu4SzC8BJQP37J/divider.jpg)
IF YOU WANT TO SUPPORT YOU CAN
![share.png](https://steemitimages.com/640x0/https://steemitimages.com/DQmfGJB8rnQa8HSDupJsiTHqoVWeQdSYywRdVVQGc1JRgpD/share.png)
and Share on Networks
![PiggyBank.jpg](https://steemitimages.com/DQmdQ7fA4gnw8bR2cqUeoPw5EzNqgfAXx44GKdLd6znyVJa/PiggyBank.jpg)
0x266936320952C248825472F2167Ec7c76829C734
It looks very usefull! but it seems not to be working for me? It returns a 'value' error in a lot of places and I think it has to do with the difference in notations (you get a '.' from the web when you need a ',' in the excel file). It's a pity because it looks really handy to use!
Yeah in some countries, the "," is used instead of the "." for the decimal separation, that's why i added a note inside the file.
The note explain that in this case, you have to go in OPTIONS > ADVANCED OPTION . Then replace the point with the comma as the decimal separator (or the contrary)
Thanks alot for your help!!
just wanted to let you know that i dont seem to find an easy way to add transactions?
If you bought 1BTC at 2500€ and later on you buy another 1BTC at 2700€, you need to change the buy price of the first transaction as well.
Yes my Table is just a tool which follows the actual price of the currencies. It is a base on which you can add your own table including what you want. I thought that many people use excel but don't know how to auto update the crypto price to serve their tables. So i dit it and after you can make your soup with this ingredient and many of yours from imagination, needs, knowledge and more.
I'll have to check this out. Thank you for sharing.
Yeah thanks ! Don't hesitate to tell me what you think of it.