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!


Frozen III (FROZ3) 10000 344.60 (+1.16)          Hot Spot (HTSPT) 150000 1.78 (+0.01)          Ewan McGregor (EMCGR) 500 69.68 (-1.22)          Diego Luna (DLUNA) 25000 31.52 (-0.13)          Buddy (BUDDY) 150000 5.67 (-0.75)          Tony (TONY) 10000 15.23 (-0.74)          Destin Daniel Cretton (DDCRE) 25000 105.76 (+0.50)          Shrek 5 (SHRK5) 245 262.61 (+3.28)          Tramell Tillman (TTILL) 25000 149.12 (-0.94)          Tramell Tillman (TTILL) 25000 149.12 (-0.94)          Godzilla x Kong: Supernova (GOKO3) 300 159.97 (+0.93)          Charli XCX (CXCX) 25000 1.71 (-2.54)          Game of Thrones: Aegon’s Conqu (GOTAC) 1 116.45 (+4.27)          Spa Weekend (SPAWK) 4000 6.44 (+0.12)          Spider-Man: Beyond the Spider-Ve (ASPD3) 300 264.55 (+3.01)          The Magic Faraway Tree (TMFAT) 93652 4.62 (+0.12)          Dune: Part Three (DUNE3) 500 265.83 (+2.12)          The Secret Life of Pets 3 (PETS3) 100 94.12 (+0.24)          Samara Weaving (SAWEA) 25000 5.17 (-1.57)          Samara Weaving (SAWEA) 25000 5.17 (-1.57)          Last Train to New York (LTTNY) 150000 0.88 (-0.06)          Olivia Wilde (OWILD) 25000 36.23 (+0.58)          Game of Thrones: Aegon’s Conqu (GOTAC) 150000 116.45 (+4.27)          Trashers (TRSHR) 150000 0.06 (-0.02)          Tramell Tillman (TTILL) 25000 149.12 (-0.94)          Mother Nature (MONAT) 150000 0.07 (0.00)          Snoop (SNOOP) 11644 37.43 (-0.22)          Lucy Boomer (LUCYB) 20000 6.04 (+0.37)          Metal Men (METAL) 150000 4.97 (-0.08)          Tramell Tillman (TTILL) 17 149.12 (-0.94)          Rosamund Pike (RPIKE) 11111 17.92 (-0.24)          Mason Gooding (MSGOO) 25000 53.13 (+0.12)          Samara Weaving (SAWEA) 25000 5.17 (-1.57)          Lesbian, Gay, Bisexual and Trans (LGBTQ) 20000 20.00 (0.00)          Scapegoat (SCAPG) 150000 20.87 (+0.87)          Olivia Wilde (OWILD) 25000 36.23 (+0.58)          Mega Man (MGAMN) 150000 0.06 (+0.01)          Olivia Wilde (OWILD) 25000 36.23 (+0.58)          Marisa Tomei (MTOME) 25000 150.11 (-0.05)          Xochitl Gomez (XGOME) 25000 116.89 (+1.89)          Avengers: Secret Wars (AVNG6) 83963 535.90 (+5.04)          Last Train to New York (LTTNY) 150000 0.88 (-0.06)          Ray Nicholson (RANIC) 25000 20.18 (-0.12)          Mason Gooding (MSGOO) 25000 53.13 (+0.12)          Francis and the Godfather (FGODF) 150000 0.06 (0.00)          Kyle Gallner (KGALL) 25000 35.64 (-0.04)          Karoshi (KAROS) 10000 11.25 (-0.05)          Fortitude (FRTUD) 27000 7.00 (-0.23)          Days of Thunder 2 (DTHU2) 50000 86.34 (+0.56)          Lilo & Stitch 2 (LILS2) 7000 288.56 (-0.02)