Since I've discovered coinmap I decided to add bitcoin and litecoin as accepted payment methods on my local business. But there's was one problem - how make the staff learn to do some math and give the customer the rigth price in litecoins and bitcoins?
So I chose the easiest way and make the excel calculator for litecoins and bitcoins. It uses the BTC-E API to get the current rates, you just type the item price into the field and excel gives you the price in coins based on rates at this exact moment.
I've make three types of calculator for three currencies: USD, EUR and Ruble. But If the main currency in your country is neither USD, EUR or RUR there's another field where you can add rate of your local currency (based on which file you choose).
The BTC-E commission is NOT included in calculations. All the formulas located on X column (so you can check how dumb the realization is, but it works:)). Currency rates updated automatically when opening the file and every 1 minute when file is opened. When opening excel may ask for security permissions at the top of the worksheet.
Links:
http://dl.dropboxusercontent.com/u/44097622/Dowload/Litecoin-Bitcoin-calculator-USD.xlsx
http://dl.dropboxusercontent.com/u/44097622/Dowload/Litecoin-Bitcoin-calculator-EUR.xlsx
http://dl.dropboxusercontent.com/u/44097622/Dowload/Litecoin-Bitcoin-calculator-RUR.xlsx
You may ask what is it for? Primarily it was made for users who don't know anything in digital currencies but they need to work with it.
Topic: BTC and LTC currensy exchange calculator (USD/EUR/RUR)..on EXCEL using BTC-E API (Read 3613 times)
December 27, 2013, 02:10:21 AM
Jump to: