GBLSE assets data spreadsheet

[ColdHardMetal]

I think what we need to be doing is referring to the mining bonds a bit differently.

A traditional bond has a fixed coupon payment at regular intervals. Most of the mining assets are variable payouts depending on the results of mining in a certain time frame, so don't fit that definition. Some payout at regular intervals, and I believe some pay out at difficulty changes, although that doesn't matter all that much I suppose.

Because of the variable nature of the coupon payment they are more like Floating Rate Notes where the coupon payment is dependent on mining results rather than LIBOR or whatever.

Maybe we need to be incorporating that term into our lexicon, instead of using the "bond" label as broadly as we have been.

[1713983915]

1713983915

[1713983915]

1713983915

[Tritonio]

I suppose this a more of a suggestion for GLBSE and not for the spreadsheet, right? Although if you can think of a better way to describe "perpetual mining bond" so that everyone understands what it is, then I'll change it in the spreadsheet.

[pyramining]

Is this valid also for Mining Ops that are outside GLBSE? Can http://www.pyramining.com/ be included?

[Tritonio]

Is this valid also for Mining Ops that are outside GLBSE? Can http://www.pyramining.com/ be included?

If they sell shares/bonds I might be able to include it somehow although I might need to make a few changes. Also I suppose there is no reason to include it if there is no market to sell and buy your shares/bonds.

After I quick read through the FAQ on the site I think that it doesn't really fit into the list. If I am wrong correct me and I'll see what I can do.



I also added more assets in the spreadsheet.

[pyramining]

No they aren't exactly shares neither bonds. When you join you rent cheap hashing power (7.75 MH/s per BTC), and it starts mining until repays your deposit, plus a bonus. It's similar to a bond but can't be traded. I don't know if it fits in your table but would be nice to compare against other mining ops expecially for the competitive price per MH/s and the very high profitability.

[Tritonio]

No they aren't exactly shares neither bonds. When you join you rent cheap hashing power (7.75 MH/s per BTC), and it starts mining until repays your deposit, plus a bonus. It's similar to a bond but can't be traded. I don't know if it fits in your table but would be nice to compare against other mining ops expecially for the competitive price per MH/s and the very high profitability.

If you could give me some way to get the number of days needed to pay back the invested value I could add it and sort it in the list.

[Tritonio]

Added more assets. I'll try to add market capitalization for all assets tommorow.

[lomax]

No 007? 

Does the puremining entry PPS need fixing?

[Tritonio]

No 007? 

Does the puremining entry PPS need fixing?

What do you mean 007?

I'll check puremining tommorow when I'll be on my computer again. :-)

[lomax]

What do you mean 007?

https://glbse.com/asset/view/007

[Tritonio]

Added 007. No idea how I missed that...
I didn't see anything wrong with PUREMINING. It's 1Mhash/s at 100% PPS (100%=1).

[brendio]

Great resource!

Could you please add BIB.PIRATE. It's a BS&T pass-through that pays weekly dividends of 0.0675 per bond.

Also, I suggest you change the thread title, since your spreadsheet covers more than just mining companies.

[der_meister]

Can we have such useful summary threads sticked?

[Tritonio]

Changed the title.
Added BIB.PIRATE. It will fetch the divident automatically when it is first paid, I can't hardcode it into the spreadsheet.
Added market capitalization. Which is (last price)*(securities issued). Is that correct?

[nimda]

Hmm... is there a way to export GLBSE in a nice parse-able format? I want to create a list of securities, sorted in descending order by

Code:

x = share_ask_price/average_dividend/average_time_between_dividends

Excluding Pirate bonds, I think that Tygrr-bond-B has the highest x value when calculated in that manner; am I right?

Edit: Going even further, I'd like to be able to create simple line graphs, which start at (-ask) and increase by the average payment period and the average dividend. This way, you could easily see how long it would take for a share of FOO.PPPPT to be more profitable than Tygrr-bond-P

Edit2: Just checked, and Foo.PPPPT is now .11/share cheaper than before, and it's only .02 more expensive than Tygrr-bond-P

[Sukrim]

Dividends will hopefully soon be part of the official API, an inofficial version is already working (https://bitcointalk.org/index.php?topic=74711.msg911270#msg911270), the rest of your data is calculable from that and/or already available.

[nimda]

Cool, I'll wait.
Thanks

[Tritonio]

I won't have proper Internet for two days.  I'll see if I can give more export formats when I get back.  Currently I parse the asset's page to see the dividents. That API would be helpful.

[publio]

to get dividends call:

/api/dividends/asset/ticker_symbol

for actively traded assets go to:


/api/market/assets

It's not mentioned on the info page.

[GeoRW]

Added market capitalization. Which is (last price)*(securities issued). Is that correct?

It is not correct. As number of securities you can use the number of shares for which dividend was paid last time, but as a lot of assets didn't pay any dividend yet and also some of them are bought back on a monthly basis (PPT bonds) just after dividend payment, you have no way to find out exact number of shares outstanding on the market until GLBSE will show this number or issuers of those assets will tell you (if you want to update those numbers manually)

You can check the thread I started here: https://bitcointalk.org/index.php?topic=84399.0