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!


Them (THEM) 100000 43.21 (+3.21)          Michael (MJACK) 2 244.74 (+0.77)          The Breadwinner (BREDW) 2 26.33 (+0.90)          Angel and the Badman (ANBAD) 10000 13.45 (+1.35)          The Breadwinner (BREDW) 2 26.33 (+0.90)          April X (APRLX) 150000 2.00 (0.00)          Ryan Gosling (RGOSL) 3000 150.58 (+0.56)          By Design (BYDSG) 995 0.05 (-0.02)          The Bookie & the Bruiser (TBATB) 900 7.10 (+0.47)          The Cat in the Hat (TCATH) 20 88.77 (-0.14)          The Cat in the Hat (TCATH) 20 88.77 (-0.14)          Christopher Nolan (CNOLA) 300 183.87 (+0.50)          The Isolate Thief (ISOLT) 2 0.76 (+0.01)          Them (THEM) 8 43.21 (+3.21)          The Bookie & the Bruiser (TBATB) 150000 7.10 (+0.47)          The Bookie & the Bruiser (TBATB) 150000 7.10 (+0.47)          Minions & Monsters (MNIO3) 1 325.69 (-0.25)          Thumb (THUM) 66666 5.03 (+0.08)          Passenger (PSNGR) 2 28.51 (+0.03)          The Catch (TCATC) 150000 57.44 (+3.45)          Mortal Kombat II (MKMB2) 150000 100.41 (-1.16)          Seth Rogen (SROGE) 1 127.44 (-0.03)          Deep Water (DEEPW) 150000 4.08 (-0.36)          American Son (AMRSN) 805 0.06 (0.00)          Colony (CLONY) 66666 1.87 (-0.09)          Hello Kitty (HLOKT) 50 34.08 (0.00)          The Man I Love (TMILV) 150000 4.51 (-0.37)          American Son (AMRSN) 7994 0.06 (0.00)          Hello Kitty (HLOKT) 100 34.08 (0.00)          The Horror Fund X (SPOOK) 20000 25.87 (+0.12)          The Sheep Detectives (3BAGF) 150000 47.02 (-1.80)          Love is Not the Answer (LINTA) 66666 4.33 (-0.01)          The Sun Never Sets (TSNVS) 150000 2.28 (+0.55)          The Horror Fund X (SPOOK) 20 25.87 (+0.12)          Anne Hathaway (AHATH) 300 24.73 (+1.00)          Gail Daughtry and the Celebrity (GDCSP) 10000 9.81 (+0.15)          White Elephant (WELEP) 20000 18.00 (0.00)          Rolling Loud (RLOUD) 150000 10.46 (+0.98)          Tony (TONY) 150000 14.93 (+1.99)          Rosebush Pruning (RPRUN) 66666 1.48 (0.00)          Them (THEM) 150000 43.21 (+3.21)          White Elephant (WELEP) 60000 18.00 (0.00)          Possession (PSESN) 55555 31.20 (+0.06)          The Six Billion Dollar Man (6MILL) 150000 6.40 (-0.05)          Lorne (LORNE) 150000 0.99 (-0.02)          Ono Ghost Market (ONOGM) 30000 87.88 (+0.83)          Seth Rogen (SROGE) 3 127.44 (-0.03)          Charli XCX (CXCX) 25000 28.34 (-0.38)          The Catch (TCATC) 150000 57.44 (+3.45)          Them (THEM) 150000 43.21 (+3.21)