Author Topic: My Excel formula dealing with MtGox and BTC-e - investment vs profit  (Read 4696 times)

Offline PandaMiner

  • Jr. Member
  • **
  • Posts: 100
  • David
    • Silver Investor
Hey guys and gals.

I made this last night and thought I would share.  This spreadsheet keeps track of my investment in litecoins.  It has my MtGox USD in, the exchange rate to get BTC, minus their fee, then the rate on BTC-e going from BTC to LTC minus their fee, and finally the USD value at time of trade, versus today's value (based on today's USD rate)

I am open to critiques, and questions.


(click to enlarge)

Here it is on my dropbox. Feel free to play with "today's rate" and see how the profit drops or rises.
https://dl.dropbox.com/u/87896183/USD-BTC-LTC-exchange-copy.xlsx
~Dave~


Start mining with your Gridseed asic tomorrow!
For all your mining needs - Hash Master Technology. Over 10,000 units sold.
Take a look around at Hash-Master.com!

Offline bjornltc

  • Newbie
  • *
  • Posts: 3
Re: My Excel formula dealing with MtGox and BTC-e - investment vs profit
« Reply #1 on: January 06, 2013, 02:30:25 PM »
thanks

Offline Carnth

  • Administrator
  • Elite Member
  • *****
  • Litecoin Association Member
  • ***
  • Posts: 1644
  • Litecoin Association
Re: My Excel formula dealing with MtGox and BTC-e - investment vs profit
« Reply #2 on: February 18, 2013, 01:15:25 AM »
Here it is on my dropbox. Feel free to play with "today's rate" and see how the profit drops or rises.
https://dl.dropbox.com/u/87896183/USD-BTC-LTC-exchange-copy.xlsx

I don't know if you have a Google Account, but if you could convert this to an Google Doc (Drive) spreadsheet, you would make it accessible to many more people.

Offline mai77

  • Newbie
  • *
  • Posts: 2
Re: My Excel formula dealing with MtGox and BTC-e - investment vs profit
« Reply #3 on: April 03, 2013, 04:21:07 PM »
ok now we must put in API calls for current exchg rates

this is an offline calc sheet, way too tedious

I modified the spreadsheet for EUR / bitcoin.de / LTC

but I cant post attachment. too bad  :-[
« Last Edit: April 03, 2013, 07:47:58 PM by mai77 »

Offline mai77

  • Newbie
  • *
  • Posts: 2
« Last Edit: April 04, 2013, 01:12:48 PM by mai77 »