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!


Michael Sarnoski (MSARN) 4 50.33 (-0.17)          Fede Alvarez (FALVA) 4 69.25 (-0.25)          Melissa Barrera (MBARR) 66 44.11 (-0.16)          Toy Story 5 (TOYS5) 150000 424.65 (-1.78)          Lewis Tan (LTAN) 6 124.00 (-0.66)          The Odyssey (ODYSE) 150000 311.60 (-1.64)          Supergirl (SUPGR) 16807 110.00 (-5.11)          Stephen Graham (SGRAH) 8 77.16 (-0.50)          Milly Alcock (MALCO) 49 54.73 (-1.83)          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)          Monica Barbaro (MBARB) 3 112.15 (+0.33)          Moana - Opening Weekend (MOAN1.OW) 18394 97.79 (-2.33)          Kiernan Shipka (KSHIP) 3 85.27 (+0.25)          Milly Alcock (MALCO) 25000 54.73 (-1.83)          Meryl Streep (MSTRE) 3 144.62 (0.00)          Ruby Rose (RROSE) 3 82.68 (+0.25)          Supergirl (SUPGR) 13000 110.00 (-5.11)          Jane (JANE1) 820 11.51 (-0.06)          Meryl Streep (MSTRE) 25000 144.62 (0.00)          The Man with the Bag (TMWTB) 125 7.71 (0.00)          Masters of the Universe (HEMAN) 150000 62.22 (+0.44)          Tower of Terror (TOWRT) 3 10.73 (-0.02)          Top Gun 3 (TOPG3) 60 198.74 (-0.01)          Star Wars: Dawn of the Jedi (STRW1) 13 81.49 (+0.83)          Evil Dead Burn - Opening Weekend (EVLD6.OW) 100000 23.02 (-0.47)          Sunny (SUNNY) 4 18.33 (+0.04)          Matthias Schoenaerts (MSCHO) 25000 29.99 (-0.75)          The Odyssey (ODYSE) 150000 311.60 (-1.64)          The Bourne Dilemma (BORN6) 4 78.76 (-0.08)          Black Panther 3 (BPNT3) 4 234.60 (0.00)          Supergirl (SUPGR) 150000 110.00 (-5.11)          Broadsword (BROSW) 4 44.99 (-0.10)          Billion Dollar Spy (BDSPY) 4 4.94 (-0.01)          James Bond 26 (JB26) 2 162.80 (-0.04)          The Lunar Chronicles (LUNAR) 7 60.47 (-0.35)          Artificial (AIFIC) 87 11.50 (+0.03)          Artificial (AIFIC) 6995 11.50 (+0.03)          Jehanne d'Arc (JDARC) 8 31.11 (+0.23)          Gladys aka Weapons prequel (WEPN2) 13 70.71 (+0.71)          Tom Holland (TOHOL) 10000 142.72 (-0.20)          Scary Movie H$105M Blockbuster W (SCAR6.BW) 25000 5.00 (0.00)          Luca Guadagnino (LGUAD) 2 10.72 (0.00)          Ice Age: Boiling Point (ICEA6) 3 85.12 (-0.08)          Zorro 2.0 (ZOROR) 150000 0.01 (-0.02)          The Flood (FLOOD) 5 85.55 (+0.18)          X-Men aka Mutants (XMEN8) 50000 169.42 (+0.33)          Hello Kitty (HLOKT) 3 36.12 (+0.07)          Jackass: Best and Last (JCKA6) 150000 28.99 (-3.62)          Dynamic Duo (DYDUO) 5 120.63 (+0.37)