HSX Forum

CelebStock and StarBonds

Overview notes from RogerMore

Posted by: edzep on Dec 14, 15:42 in response to edzep's post OK Starbond mavens, I have RogerMore's bond spreadsheet...

It should be pretty self explanatory but:
  • HSX's xml data goes onto the XML stocks and the XML bonds worksheets
  • The XML stocks data feeds into the Box Office spreadsheet.  The Box Office spreadsheet is a list of all the active and delisted Moviestocks that appear in Starbond TAGS, with their price/box office and release and delist dates.
  • The data in the XML bonds and the Box Office worksheets then feeds into the Bonds worksheet.  This is where TAGs are calculated as well as post-adjust plays, etc.  Summary information (next adjust, expected adjust, ROI etc) is on the left land side of the spreadsheet.  More detailed information - movies in the TAG and movies that may enter the TAG are on the right side, in the blue, yellow and green columns.
There are a couple of other tools as well
  • The Summary worksheet gives the expected adjust of a single Starbond, and also allows you to estimate an adjust on your own delist
  • The MyBonds worksheet is a place to paste your own Starbond holdings.  This also feeds into the Bonds worksheet, so you can check whether you are holding a bond in the same direction (or not) as the spreadsheet recommends.

More detailed instructions are on the Instructions worksheet (duh!)

OK Starbond mavens, I have RogerMore's bond spreadsheet file available... edzep Dec 14, 15:39

Overview notes from RogerMore edzep Dec 14, 15:42

where can I get a copy of the spreadsheet? {nm} RazorHawk Dec 14, 16:39

edzep has a link in his original post {nm} RogerMore Dec 14, 16:52

thanks, got confused on thought it was on his league page (uses same name) {nm} RazorHawk Dec 14, 16:59

I have some questions about the spreadsheet. Guillo Dec 14, 20:08

There is a lot of manual input and I've talked about it in detail in other posts on this board {nm} RogerMore Dec 14, 20:56

I find the sheet to be impressive. Hard to fully appreciate withouth XML to run through it. edzep Dec 15, 11:23

A week without updates won't matter so much. A month without updates will - too many changes in price, attachments, release dates, etc RogerMore Dec 15, 11:50

I have a SBO adjust spreadsheet that I might be willing to share also... KaiGee Dec 14, 15:56

Will like to give it a look if you don't mind. {nm} Guillo Dec 14, 20:10

What what? edzep Dec 15, 11:28

Since they took away the XML feeds from the non-priveledged players, it's the only way to gather the needed information. shadowking Dec 15, 12:14

I'm not saying that I do it, I'm saying that my VB macros do it. And it not quite thousands of pages. KaiGee Dec 15, 14:21

Dude I will like to know how to do this. Guillo Dec 16, 06:20

Do you know any programming? edzep Dec 16, 13:52

I know basic programing and can hold my own in excel pretty well. Guillo Dec 16, 18:49

Shoot me off an email, and I'll see what I can do for you... KaiGee Dec 16, 20:54

shadowking and KaiGee edzep Dec 15, 15:20

you guys are doing a great job etc etc. jane_citizen Dec 14, 17:43

ditto {nm} Ramdadof3 Dec 15, 04:32

you do know that my spreadsheet (which Roger helped create) is in the zip file I posted, right? {nm} ProjectGenome Dec 15, 09:36

Yes, though I did not know that initially. edzep Dec 15, 11:16

XML ProjectGenome Dec 15, 13:38





Post a Reply

To post to the forums you must first login!


It Ends (ITNDS) 149999 5.78 (+0.37)          Clarissa (CLRIS) 150000 3.84 (+0.19)          Buddy (BUDDY) 150000 8.19 (+0.10)          42.6 Years (426YR) 30000 13.79 (+0.17)          It Ends (ITNDS) 150000 5.78 (+0.37)          The Teller (TELER) 150000 7.90 (+0.11)          The Comebacker (CMBAC) 20000 29.83 (-0.24)          It Ends (ITNDS) 150000 5.78 (+0.37)          Toxic: A Fairy Tale for Grown-Up (TOXIC) 150000 3.16 (+0.14)          Mutiny (MUTNY) 150000 29.29 (+0.40)          42.6 Years (426YR) 150000 13.79 (+0.17)          Toxic: A Fairy Tale for Grown-Up (TOXIC) 149999 3.16 (+0.14)          White Lies (WHTLI) 150000 13.63 (+0.65)          Paddington 4 (PADT4) 90000 36.56 (-0.65)          Monopoly (MONOP) 90000 10.56 (+0.18)          Ramayana (RAMAY) 149999 13.28 (+0.17)          It Ends (ITNDS) 150000 5.78 (+0.37)          Wild Horse Nine (WILDH) 149999 14.12 (+0.30)          White Lies (WHTLI) 149999 13.63 (+0.65)          Shaun The Sheep: The Beast Of Mo (SHEP3) 149999 13.53 (+0.17)          Monopoly (MONOP) 59999 10.56 (+0.18)          White Lies (WHTLI) 149999 13.63 (+0.65)          The Last Druid (TLDRU) 150000 7.44 (-0.22)          Ice Cream Man (ICREM) 149999 19.12 (+0.17)          It Ends (ITNDS) 150000 5.78 (+0.37)          Charlie Harper (CHARP) 150000 4.97 (+0.34)          The Last Druid (TLDRU) 150000 7.44 (-0.22)          Clarissa (CLRIS) 75000 3.84 (+0.19)          Charlie Harper (CHARP) 149999 4.97 (+0.34)          Paddington 4 (PADT4) 50000 36.56 (-0.65)          Monopoly (MONOP) 150000 10.56 (+0.18)          Wild Horse Nine (WILDH) 150000 14.12 (+0.30)          It Ends (ITNDS) 150000 5.78 (+0.37)          Hershey (HERSH) 149999 14.39 (+0.18)          Clarissa (CLRIS) 150000 3.84 (+0.19)          Wild Horse Nine (WILDH) 150000 14.12 (+0.30)          Mutiny (MUTNY) 150000 29.29 (+0.40)          White Lies (WHTLI) 150000 13.63 (+0.65)          Charlie Harper (CHARP) 150000 4.97 (+0.34)          Paddington 4 (PADT4) 50000 36.56 (-0.65)          Mutiny (MUTNY) 149999 29.29 (+0.40)          It Ends (ITNDS) 129999 5.78 (+0.37)          Minotaur (MNTUR) 150000 1.08 (+0.05)          Charlie Harper (CHARP) 150000 4.97 (+0.34)          White Lies (WHTLI) 150000 13.63 (+0.65)          It Ends (ITNDS) 150000 5.78 (+0.37)          White Lies (WHTLI) 150000 13.63 (+0.65)          Paddington 4 (PADT4) 50000 36.56 (-0.65)          The Last Druid (TLDRU) 150000 7.44 (-0.22)          The Last Druid (TLDRU) 149986 7.44 (-0.22)