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!


Crime 101 - Opening Weekend Fri- (CRIM1.OW) 100000 10.88 (+0.05)          Stephen Graham (SGRAH) 25000 95.00 (0.00)          Heel (HEEL) 150000 1.00 (0.00)          Heel (HEEL) 150000 1.00 (0.00)          Shelter (SELTR) 900 12.33 (-0.93)          The Beatles - A Four-Film Cinema (BEAT1) 10000 112.69 (-0.36)          F.A.S.T. (FAST) 150000 42.90 (0.00)          Shiver (SHVER) 62135 62.30 (-1.85)          Bluey the Movie (BLUEY) 10000 133.73 (-0.09)          The Strangers: Chapter 3 (STRN5) 88072 12.35 (+0.85)          Heel (HEEL) 150000 1.00 (0.00)          Shiver (SHVER) 14189 62.30 (-1.85)          The Odyssey (ODYSE) 499 292.94 (+0.53)          Sydney Sweeney (SSWEE) 25000 35.59 (+0.37)          Scream 7 (SCRM7) 45 81.89 (+0.35)          Star Wars: Dawn of the Jedi (STRW1) 150000 109.79 (+0.76)          Hello Kitty (HLOKT) 150000 29.41 (+0.03)          Scream 7 (SCRM7) 100 81.89 (+0.35)          Star Wars: Dawn of the Jedi (STRW1) 150000 109.79 (+0.76)          Stephen Graham (SGRAH) 25000 95.00 (0.00)          Scream 7 (SCRM7) 100 81.89 (+0.35)          Star Wars: Dawn of the Jedi (STRW1) 150000 109.79 (+0.76)          Heel (HEEL) 150000 1.00 (0.00)          Heel (HEEL) 149393 1.00 (0.00)          Star Wars: Dawn of the Jedi (STRW1) 1000 109.79 (+0.76)          John Wick: Chapter 5 (WICK5) 5000 109.56 (+2.48)          The Custom of the Country (TCOTC) 1000 19.02 (+2.35)          Incredibles 3 (NCRD3) 2604 350.34 (+0.01)          Heel (HEEL) 150000 1.00 (0.00)          The Drama (TDRAM) 150000 22.76 (+0.50)          Wicked: For Good $315M Blockbust (WCKD2.BW) 5000 13.87 (-0.05)          The Custom of the Country (TCOTC) 8000 19.02 (+2.35)          Jurassic World sequel (JURA8) 900 242.62 (-0.16)          Shiver (SHVER) 129999 62.30 (-1.85)          Daisy Ridley (DRIDL) 25000 2.43 (-0.02)          Heel (HEEL) 150000 1.00 (0.00)          Heel (HEEL) 150000 1.00 (0.00)          Ralph Fiennes (RFIEN) 25000 26.09 (+0.12)          Supergirl (SUPGR) 25000 181.30 (+0.11)          Stephen Graham (SGRAH) 25000 95.00 (0.00)          Ebenezer: A Christmas Carol (EBNZR) 25000 73.28 (+0.26)          Buffalo Kids (BUFKS) 150000 2.86 (+0.10)          Buffalo Kids (BUFKS) 150000 2.86 (+0.10)          Gus Van Sant (GVSAN) 25000 2.40 (-0.02)          Disclosure Day (SKIES) 24999 162.87 (+0.23)          The Super Mario Galaxy Movie (MARI2) 25000 498.75 (+0.43)          Avatar: Fire and Ash $345M Block (AVAT3.BW) 1000 13.83 (+0.08)          Street Fighter (STFTR) 1 73.21 (-0.17)          Wuthering Heights - Opening Week (WUTHR.OW) 5000 50.08 (+0.21)          Dog Stars (DOGST) 1 63.23 (+0.01)