Bitcoin Forum

I guess it makes it a bit easier and visible if I share this in a seperate thread as well:

As I track my earnings from lending out USD and BTC on bitfinex.com and I like numbers, I created the following spreadsheet + charts on Google docs:
https://docs.google.com/spreadsheet/ccc?key=0AjDrki5tpdL3dFlYaU53cVozazJiYWo2S1ZQMHZiRWc#gid=5

It is filled with bogus data, but it's anyways to be used as template by you, simply create a copy yourself, delete the explanation sheet (after reading it) and enter your own data.
I hope this helps a few people to better track their earnings and maybe there are even some improvements to be made on this (eventually for example I plan to have some kind of ledger sheet and then weekly/monthly/yearly reports + charts) that I didn't think of yet.

As usual: No warranties, don't start plotting your plan on world domination with this sheet and always stay a bit critical towards stuff posted on the net!


Edit:
Changelog:
2013-04-12: Initial release
2013-04-12: Added IFERROR() statements in columns G-J, thanks superbit! (https://bitcointalk.org/index.php?topic=119745.msg1822082#msg1822082)

Not reserved, I double post just because I'm that cool!

/sub and bump

I just found Bitfinex and I am wondering what your chart would show me, but I would like to know prior to forking over $1,000s of dolalrs what the average rate is. I mean as your bogus data shows it is could be possible your money is not used and is just sitting there.

How often do people actually use the loans available there?

It heavily depends on both other lenders and the bitcoin price vs. USD.

Rising prices usually mean traders need more money for long positions, so lots of loans get taken. Also if there are a lot of other lenders it might push down interest.

As you would directly compete with me by lending out money, why should I help you?  ;)
I made good returns so far, what also has to be considered is that you can either lend out 10 hours at 100% or 1 hour at 1000% so idle funds are not that bad if there are traders who desperately need money once in a while. Its a bit of a poker game though...

Oh, and depending on other lenders and their "smartness" (auto lend at 2 digit rates per year if bitcoins grows at 2 digit rates per day...) it might not give as high returns as you might expect during rallies.

My average rate in bitcoins as of yersterday is nearly 2.7% apr over 55 days. For the 41 days of USD it is definitely higher.
If you were just buying 41 days ago and holding however, there might have been better returns still. Hindsight is always 20/20 though, so I chose the path with less risk. Still traders can make much more than lenders per day if I just look at the charts.

You could start small and check out the returns for yourself as they also depend on your lending strategy, also 1 reason why I built into this sheet the ability to track several deposits and not just an initial amount.