Bitcoin Forum
May 07, 2024, 03:30:27 AM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: BTC and LTC currensy exchange calculator (USD/EUR/RUR)..on EXCEL using BTC-E API  (Read 3583 times)
homastudio (OP)
Newbie
*
Offline Offline

Activity: 4
Merit: 0


View Profile
December 27, 2013, 07:10:21 AM
 #1

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.
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!