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!


Charli XCX (CXCX) 25000 1.71 (-2.54)          Sadie Sink (SSINK) 25000 71.25 (+1.61)          The Brink of War (REYKJ) 1319 5.43 (+0.20)          Alice Eve (AEVE) 25000 8.22 (-0.06)          The Cat in the Hat (TCATH) 4034 104.15 (+1.06)          Alice Eve (AEVE) 5000 8.22 (-0.06)          Sandra Huller (SHULL) 25000 52.78 (+3.48)          Coyote vs. ACME H$15 Put (CVACM.PU) 25000 1.96 (-0.21)          Coyote vs. ACME (CVACM) 92852 45.29 (+1.14)          Coyote vs. ACME - Opening Weeken (CVACM.OW) 100000 17.86 (+0.93)          Coyote vs. ACME H$15 Call (CVACM.CA) 25000 3.78 (+0.08)          The Dog Stars (DOGST) 1 47.84 (-2.70)          Coyote vs. ACME (CVACM) 100001 45.29 (+1.14)          The Dog Stars H$20 Call (DOGST.CA) 25000 1.09 (0.00)          Lesbian, Gay, Bisexual and Trans (LGBTQ) 20000 20.00 (0.00)          Scapegoat (SCAPG) 149999 21.02 (+1.02)          Coyote vs. ACME (CVACM) 149900 45.29 (+1.14)          Alice Eve (AEVE) 25000 8.22 (-0.06)          The Dog Stars H$20 Put (DOGST.PU) 25000 3.43 (+0.33)          Cooper Hoffman (CHOFF) 25000 12.79 (+0.21)          Evil Dead Wrath (EVLD7) 150000 34.71 (+0.02)          Chase Sui Wonders (CSWON) 25000 15.01 (+0.20)          Cooper Hoffman (CHOFF) 25000 12.79 (+0.21)          Destin Daniel Cretton (DDCRE) 25000 105.76 (+0.50)          Michael 2 (MJAC2) 6593 186.64 (+0.68)          Cooper Hoffman (CHOFF) 25000 12.79 (+0.21)          Zendaya (ZENDA) 25000 169.62 (+36.79)          Christopher Miller (CMILL) 25000 190.09 (0.00)          Ving Rhames (VRHAM) 25000 152.65 (-1.40)          Bingbing Fan (FBING) 25000 96.35 (+0.25)          50 Cent Curtis Jackson (50CEN) 25000 48.85 (-0.16)          Martin Campbell (MCAMP) 25000 32.99 (-0.12)          Robert Rodriguez (RRODR) 25000 19.67 (+0.10)          Jessie Buckley (JSBUC) 25000 9.86 (+0.07)          In the Hand of Dante (ITHOD) 150000 0.10 (-0.02)          David Harbour (DHARB) 25000 76.97 (+0.50)          Sally Hawkins (SHAWK) 25000 50.09 (+0.16)          Sally Hawkins (SHAWK) 25000 50.09 (+0.16)          Pierre Morel (PMORE) 25000 45.54 (+0.16)          Pierre Morel (PMORE) 25000 45.54 (+0.16)          Tom Holland (TOHOL) 25000 182.33 (+25.63)          Shirley MacLaine (SMACL) 25000 37.25 (+0.12)          Shirley MacLaine (SMACL) 25000 37.25 (+0.12)          Gal Gadot (GGADO) 25000 99.72 (0.00)          Gal Gadot (GGADO) 25000 99.72 (0.00)          Emma Mackey (EMACK) 25000 55.05 (0.00)          Emma Mackey (EMACK) 25000 55.05 (0.00)          Jacob Batalon (JBATA) 25000 107.84 (-1.15)          Brendan Gleeson (BGLEE) 25000 15.50 (0.00)          Charli XCX (CXCX) 25000 1.71 (-2.54)