HSX Forum

CelebStock and StarBonds

Movies are dropped from the TAG in order of RELEASE date, oldest first. In case of a tie (MDAMO coming up) the lower box office drops first

Posted by: Buy BONDS 20 (a.k.a StarBondFund) on Jun 27, 11:03 in response to elchan's post Interesting conundrum, RISE opened ealier, than FOUR2, so...

In the case of RREYN, for example, TURB1 is opening 2 days earlier than RIPD.  They will adjust simultaneously because they delist on the same date, but down the road, TURB1 will drop from the TAG first.

In the case of MLPAR who has RIPD and RED2 opening on the same date, the movie with the lower box office total (not delist amount) will drop from the TAG first.

In the case of MCHIK, ARISE opened before FOUR2 and will be dropped from the TAG first.   Once they are in the TAG, the adjust dated DOES NOT MATTER, only release date.

In programming, you need to have 2 fields.  A release date field, which I assume you have, and an adjust date field, calculated from the adjust date.  (Normally +25 or +81) You may need a release date adjustment field to calculate for days before (or after) Friday for those movies not released on a Friday.  You probably have a wide/limited marker field.   But movies out of the TAG have to be sorted by release date as first critereon, and box office as the tie-breaker.

I am not sure if you are entering the movies manually into the 1,2,3,4,5 spots, or are programming it. 

NEW! Another feature added to HowProfitable. Integration of portfolio check into bonds chart. elchan Jun 25, 21:57

Not sure if this has been fixed. MFREE Nov 26/13 drops MGCBI ($.010) not BATM3 so goes up not down. {nm} grammar Jun 25, 22:32

Fixed the code, all the bonds should start updating about 10 am PST. Thanks for catching that. {nm} elchan Jun 26, 06:50

BTW, bonds are driving me crazy and I'm finding it tedious due to the number of non-reporting movie stocks. grammar Jun 25, 22:35

Ok, I put in some code to not include zero bo movies, if they are released for > 2 weeks and not include delisted zero bo. {nm} elchan Jun 26, 15:28

Elchan I luv this new feature. I copied my bond port (from your site) to Xcel as I find it easier with static titles and every thing copies grammar Jun 25, 22:56

is it me, or is something wrong with your MCHIK adjust on 7/9? {nm} lapuckfan Jun 26, 17:06

Hope not, RISE was limited and opened earlier than FOUR2, so it drops first. That's the new code I added in today. {nm} elchan Jun 26, 17:40

it shows RISE dropping, but seems to be using the price of FOUR2 (I've noticed this type of problem on a few others too) {nm} lapuckfan Jun 26, 17:48

My understanding is that TAGS are calculated in delist order and Drops are calculated in release order. FOUR2 delisted before RISE. {nm} elchan Jun 26, 20:12

Sorry, I was unclear. The chart correctly shows that RISE is the movie being dropped, but it incorrectly drops the value of FOUR2 {nm} lapuckfan Jun 26, 23:55

Interesting conundrum, RISE opened ealier, than FOUR2, so should drop first, but it also delisted after FOUR2, so should in used ... elchan Jun 27, 08:45

Movies are dropped from the TAG in order of RELEASE date, oldest first. In case of a tie (MDAMO coming up) the lower box office drops first Buy BONDS 20 Jun 27, 11:03

just to further clarify, using MCHIK... lapuckfan Jun 27, 11:40

Poifekt. {nm} Buy BONDS 20 Jun 27, 12:17

Ok, that's good information. I recalculated MCHIK, with all the rules in your message, and it matches with lapuckfan's calculations below. elchan Jun 27, 13:51





Post a Reply

To post to the forums you must first login!


Disclosure Day (SKIES) 20000 103.98 (-1.39)          Jackass: Best and Last (JCKA6) 50000 29.25 (-3.36)          The Flood (FLOOD) 12500 85.55 (+0.18)          La Bola Negra aka The Black Ball (LBNEG) 150000 1.00 (0.00)          Scary Movie H$105M Blockbuster W (SCAR6.BW) 25000 5.00 (0.00)          Deathstroke & Bane (DSTRK) 12500 65.51 (+5.51)          Toy Story 5 (TOYS5) 20000 424.66 (-1.77)          Scary Movie H$105M Blockbuster W (SCAR6.BW) 25000 5.00 (0.00)          Chitty Chitty Bang Bang (CCBB) 9 15.60 (0.00)          Deathstroke & Bane (DSTRK) 150000 65.51 (+5.51)          Evil Dead Burn (EVLD6) 150000 61.87 (+0.05)          Supergirl (SUPGR) 100000 110.03 (-5.08)          Minions & Monsters (MNIO3) 150000 313.41 (-1.01)          Scary Movie H$105M Blockbuster W (SCAR6.BW) 498 5.00 (0.00)          The Last Druid (TLDRU) 150000 6.21 (+1.32)          Jeremy Allen White (JEAWH) 24438 45.36 (-0.01)          Young Washington - Opening Weeke (YWASH.OW) 200 13.45 (+0.05)          Supergirl (SUPGR) 150000 110.03 (-5.08)          Rosa Salazar (RSALA) 25000 60.02 (+0.16)          The Last Druid (TLDRU) 20000 6.21 (+1.32)          Scary Movie H$105M Blockbuster W (SCAR6.BW) 25000 5.00 (0.00)          Selena Gomez (SGOME) 25000 104.48 (-0.66)          La Bola Negra aka The Black Ball (LBNEG) 150000 1.00 (0.00)          Scary Movie H$105M Blockbuster W (SCAR6.BW) 6592 5.00 (0.00)          Spider-Woman (SPDWM) 25000 17.09 (+0.01)          Allison Janney (AJANN) 25000 77.42 (+0.50)          Young Washington - Opening Weeke (YWASH.OW) 2500 13.45 (+0.05)          Jackass: Best and Last (JCKA6) 82 29.25 (-3.36)          Scary Movie H$105M Blockbuster W (SCAR6.BW) 25000 5.00 (0.00)          Scary Movie H$105M Blockbuster W (SCAR6.BW) 25000 5.00 (0.00)          La Bola Negra aka The Black Ball (LBNEG) 150000 1.00 (0.00)          Scary Movie H$105M Blockbuster W (SCAR6.BW) 25000 5.00 (0.00)          Scary Movie H$105M Blockbuster W (SCAR6.BW) 25000 5.00 (0.00)          La Bola Negra aka The Black Ball (LBNEG) 150000 1.00 (0.00)          La Bola Negra aka The Black Ball (LBNEG) 150000 1.00 (0.00)          Scary Movie H$105M Blockbuster W (SCAR6.BW) 25000 5.00 (0.00)          La Bola Negra aka The Black Ball (LBNEG) 150000 1.00 (0.00)          La Bola Negra aka The Black Ball (LBNEG) 150000 1.00 (0.00)          La Bola Negra aka The Black Ball (LBNEG) 150000 1.00 (0.00)          Tyrese Gibson (TYGIB) 25000 96.16 (+0.50)          Deathstroke & Bane (DSTRK) 150000 65.51 (+5.51)          Alien sequel (ALIE6) 100000 78.12 (-0.41)          Scary Movie H$105M Blockbuster W (SCAR6.BW) 25000 5.00 (0.00)          Sam Worthington (SWORT) 25000 57.85 (-0.16)          Minions & Monsters (MNIO3) 6000 313.41 (-1.01)          Scary Movie H$105M Blockbuster W (SCAR6.BW) 25000 5.00 (0.00)          La Bola Negra aka The Black Ball (LBNEG) 150000 1.00 (0.00)          A Quiet Place: Part III (AQPL4) 1 121.10 (+0.11)          Minions & Monsters - Opening (MNIO3.OW) 20000 81.47 (-1.27)          Deathstroke & Bane (DSTRK) 149943 65.51 (+5.51)