Bitcoin Forum
May 03, 2024, 08:18:57 PM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Bitfinex.com lending interest tracking sheet  (Read 1276 times)
Sukrim (OP)
Legendary
*
Offline Offline

Activity: 2618
Merit: 1006


View Profile
April 12, 2013, 06:27:43 PM
Last edit: April 12, 2013, 11:09:53 PM by Sukrim
 #1

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)

https://www.coinlend.org <-- automated lending at various exchanges.
https://www.bitfinex.com <-- Trade BTC for other currencies and vice versa.
"Bitcoin: mining our own business since 2009" -- Pieter Wuille
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction.
1714767537
Hero Member
*
Offline Offline

Posts: 1714767537

View Profile Personal Message (Offline)

Ignore
1714767537
Reply with quote  #2

1714767537
Report to moderator
Sukrim (OP)
Legendary
*
Offline Offline

Activity: 2618
Merit: 1006


View Profile
April 12, 2013, 06:28:36 PM
 #2

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

https://www.coinlend.org <-- automated lending at various exchanges.
https://www.bitfinex.com <-- Trade BTC for other currencies and vice versa.
myself
Legendary
*
Offline Offline

Activity: 938
Merit: 1000


chaos is fun...…damental :)


View Profile
April 12, 2013, 10:23:09 PM
 #3

/sub and bump

Los desesperados publican que lo inventó el rey que rabió, porque todo son en el rabias y mas rabias, disgustos y mas disgustos, pezares y mas pezares; si el que compra algunas partidas vé que baxan, rabia de haver comprado; si suben, rabia de que no compró mas; si compra, suben, vende, gana y buelan aun á mas alto precio del que ha vendido; rabia de que vendió por menor precio: si no compra ni vende y ván subiendo, rabia de que haviendo tenido impulsos de comprar, no llegó á lograr los impulsos; si van baxando, rabia de que, haviendo tenido amagos de vender, no se resolvió á gozar los amagos; si le dan algun consejo y acierta, rabia de que no se lo dieron antes; si yerra, rabia de que se lo dieron; con que todo son inquietudes, todo arrepentimientos, tododelirios, luchando siempre lo insufrible con lo feliz, lo indomito con lo tranquilo y lo rabioso con lo deleytable.
PachucoBro
Newbie
*
Offline Offline

Activity: 56
Merit: 0



View Profile WWW
April 24, 2013, 03:17:35 AM
 #4

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?
Sukrim (OP)
Legendary
*
Offline Offline

Activity: 2618
Merit: 1006


View Profile
April 24, 2013, 08:30:59 AM
 #5

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?  Wink
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.

https://www.coinlend.org <-- automated lending at various exchanges.
https://www.bitfinex.com <-- Trade BTC for other currencies and vice versa.
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!