Hello, fellow COMM coiners.
Ive finally got around to doing the COMM coin value/portfolio calculator
See here:-
![](https://ip.bitcointalk.org/?u=http%3A%2F%2Fi60.tinypic.com%2Fostqwm.png&t=665&c=gfM9kAt61f5yPA)
The calculator can be downloaded from Google Drive (You will need to sign in and the use File and Make a Copy)
https://docs.google.com/spreadsheet/ccc?key=0AvKAa4anuhytdGdIZ25BaE5DYVpQZWJUNkZ4OVgzVXc&usp=sharingThe Currency is set to GBP, This can be changed by changing the following:-
Currency conversion using Google Finance, Select field B18 and change the "CURRENCY:GBPUSD" to "CURRENCY:EURUSD" for example. Obviously this uses the typical three character currency identifier.
Then... BTC and LTC reference a script within Script Manager, COMM (COMM displays the value in BTC this does a lookup to the Cryptsy API (
http://pubapi.cryptsy.com/api.php?method=singlemarketdata&marketid=198)
BTC and LTC use a lookup from BTC-E API, The supported currencies you can modify are:-
Currency List: USD, AUD, CAD, CHF, CNY, DKK, EUR, GBP, HKD, JPY, NZD, PLN, RUB, SEK, SGD, THB
You can then modify the {currency = "usd";} within Tools > Script Manager to EUR for example.
Then obviously just edit the fields that currently have the Euro entered.
This looks more complicated than it is!
Hopefully be of use to some, And by all means please feel free to edit and distribute to promote this fantastic coin.
If you want to tip, It would be very much appreciated
![Smiley](https://bitcointalk.org/Smileys/default/smiley.gif)
COMM: CRbDzs2h85Syu2o4b4DRJ7mht2L9Ty2Q8U
Let do all we can to get COMM to where it deserves
Just to keep the community informed, I am dealing with the website designer to look into having the value calculator on the comm website
![Smiley](https://bitcointalk.org/Smileys/default/smiley.gif)
Great times ahead for COMM