Bitcoin Forum
October 19, 2017, 05:39:17 AM *
News: Latest stable version of Bitcoin Core: 0.15.0.1  [Torrent]. (New!)
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: Bitfinex.com lending interest tracking sheet  (Read 1190 times)
Sukrim
Legendary
*
Offline Offline

Activity: 2156


View Profile
April 12, 2013, 06:27:43 PM
 #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://bitfinex.com <-- leveraged trading of BTCUSD, LTCUSD and LTCBTC (long and short) - 10% discount on fees for the first 30 days with this refcode: x5K9YtL3Zb
Mail me at Bitmessage: BM-BbiHiVv5qh858ULsyRDtpRrG9WjXN3xf
1508391557
Hero Member
*
Offline Offline

Posts: 1508391557

View Profile Personal Message (Offline)

Ignore
1508391557
Reply with quote  #2

1508391557
Report to moderator
1508391557
Hero Member
*
Offline Offline

Posts: 1508391557

View Profile Personal Message (Offline)

Ignore
1508391557
Reply with quote  #2

1508391557
Report to moderator
1508391557
Hero Member
*
Offline Offline

Posts: 1508391557

View Profile Personal Message (Offline)

Ignore
1508391557
Reply with quote  #2

1508391557
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1508391557
Hero Member
*
Offline Offline

Posts: 1508391557

View Profile Personal Message (Offline)

Ignore
1508391557
Reply with quote  #2

1508391557
Report to moderator
1508391557
Hero Member
*
Offline Offline

Posts: 1508391557

View Profile Personal Message (Offline)

Ignore
1508391557
Reply with quote  #2

1508391557
Report to moderator
Sukrim
Legendary
*
Offline Offline

Activity: 2156


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

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

https://bitfinex.com <-- leveraged trading of BTCUSD, LTCUSD and LTCBTC (long and short) - 10% discount on fees for the first 30 days with this refcode: x5K9YtL3Zb
Mail me at Bitmessage: BM-BbiHiVv5qh858ULsyRDtpRrG9WjXN3xf
myself
Legendary
*
Offline Offline

Activity: 938


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
Jr. Member
*
Offline Offline

Activity: 56



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
Legendary
*
Offline Offline

Activity: 2156


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://bitfinex.com <-- leveraged trading of BTCUSD, LTCUSD and LTCBTC (long and short) - 10% discount on fees for the first 30 days with this refcode: x5K9YtL3Zb
Mail me at Bitmessage: BM-BbiHiVv5qh858ULsyRDtpRrG9WjXN3xf
Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!