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!


Wicker (WCKER) 1000 22.18 (-0.27)          Carnival: At the End of Days (CAEOD) 40000 7.23 (+0.02)          Grandgear (GGEAR) 1 60.12 (+0.37)          They Know (TKNOW) 30026 15.75 (+2.68)          Dragon (DRAGO) 150000 5.08 (+1.08)          They Know (TKNOW) 1 15.75 (+2.68)          The Hole (THHOL) 1 7.05 (+1.23)          The Asian Fund (ASIAN) 20000 20.31 (+0.01)          Ji-young Yoo (JYOO) 1 21.51 (+0.13)          Twilight of the Dead (TWOTD) 1 3.01 (-0.53)          Tyrant (TYRNT) 1 21.73 (+1.01)          Chloe Grace Moretz (CMORE) 20000 39.84 (-0.12)          Chloe Grace Moretz (CMORE) 20000 39.84 (-0.12)          Giancarlo Esposito (GESPO) 20000 48.73 (-0.34)          Giancarlo Esposito (GESPO) 20000 48.73 (-0.34)          Black Panther III (BPNT3) 10000 290.90 (-0.03)          Magic: The Gathering (MGCTG) 50000 36.21 (+0.30)          Maya Hawke (MHAWK) 25000 69.31 (+0.50)          The Great Beyond aka Ghostwriter (ACRNS) 10000 87.54 (-0.80)          Olivia Cooke (OCOOK) 25000 16.09 (0.00)          The Hunger Games: Sunrise on the (HGAM6.OW) 4696 93.96 (+1.92)          Gareth Edwards (GEDWA) 25000 151.81 (-1.00)          The Comeback King (CMBKN) 5000 36.32 (-0.27)          The Further Mis-Adventures of Cl (TAOCB) 50000 14.57 (+0.43)          Jake Johnson (JMJOH) 50 116.66 (+0.33)          Ebenezer (EBNZR) 150000 86.85 (+0.58)          Twilight of the Dead (TWOTD) 149999 3.01 (-0.53)          I Play Rocky H$15 Put (IPROC.PU) 25000 1.78 (+0.29)          I Play Rocky H$15 Put (IPROC.PU) 25000 1.78 (+0.29)          Doctor Caligari’s Cabinet of W (DCCOW) 25000 17.73 (-0.36)          Ving Rhames (VRHAM) 25000 139.29 (-1.00)          Doctor Caligari’s Cabinet of W (DCCOW) 25000 17.73 (-0.36)          Fing! (FING) 25000 7.25 (-0.08)          Fing! (FING) 25000 7.25 (-0.08)          Snake Island (SNKIS) 25000 16.81 (-0.08)          Snake Island (SNKIS) 25000 16.81 (-0.08)          Martin Campbell (MCAMP) 25000 28.60 (0.00)          The Decline Of Fucking Western C (DOFWC) 25000 5.43 (+1.18)          The Decline Of Fucking Western C (DOFWC) 25000 5.43 (+1.18)          Narnia: The Magician's Neph (NARN4) 25000 42.20 (-0.45)          Bermuda (BTRIA) 2 0.18 (-0.01)          Narnia: The Magician's Neph (NARN4) 25000 42.20 (-0.45)          Dragon (DRAGO) 150000 5.08 (+1.08)          Dragon (DRAGO) 25000 5.08 (+1.08)          Ramayana (RAMAY) 19389 19.67 (-0.98)          Olivia Colman (OCOLM) 25000 43.15 (0.00)          I Play Rocky H$15 Put (IPROC.PU) 20000 1.78 (+0.29)          I Play Rocky H$15 Put (IPROC.PU) 20000 1.78 (+0.29)          Place to Be (PLCTB) 40000 1.55 (0.00)          Bermuda (BTRIA) 149980 0.18 (-0.01)