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!


Angel and the Badman (ANBAD) 75000 11.27 (+1.27)          Chris Pine (CPINE) 25000 34.71 (0.00)          The Isolate Thief (ISOLT) 150000 1.00 (0.00)          The Wrong Girls (TWRNG) 149996 9.65 (+1.40)          The Wrong Girls (TWRNG) 149992 9.65 (+1.40)          Barracuda (BRCUD) 150000 8.21 (-0.18)          Rolling Loud (RLOUD) 150000 9.98 (+0.14)          The Isolate Thief (ISOLT) 150000 1.00 (0.00)          Angel and the Badman (ANBAD) 150000 11.27 (+1.27)          Michael 2 (MJAC2) 10 159.98 (+2.82)          Alien sequel (ALIE6) 1 78.17 (+0.67)          Resident Evil (RESE8) 50000 56.26 (+2.24)          Speed the Plow (SPLOW) 150000 3.26 (-0.16)          Speed the Plow (SPLOW) 150000 3.26 (-0.16)          Nimrods aka New Years Rev (NIMRD) 14804 4.28 (-0.36)          Nimrods aka New Years Rev (NIMRD) 396 4.28 (-0.36)          Fruitcake (FRUTC) 149884 0.03 (+0.02)          The Isolate Thief (ISOLT) 150000 1.00 (0.00)          Angel and the Badman (ANBAD) 75000 11.27 (+1.27)          Avengers: Doomsday (AVNG5) 100 546.02 (+1.02)          Barracuda (BRCUD) 150000 8.21 (-0.18)          Barracuda (BRCUD) 150000 8.21 (-0.18)          The Isolate Thief (ISOLT) 150000 1.00 (0.00)          In the Grey (NGREY) 150000 19.20 (-0.16)          In the Grey (NGREY) 150000 19.20 (-0.16)          Angel and the Badman (ANBAD) 150000 11.27 (+1.27)          The Amazing Digital Circus: The (AMZDC) 150000 18.76 (+0.21)          Star Wars: The Mandalorian and G (SWAR3) 5000 201.65 (-2.00)          Verity (VERTY) 150000 46.50 (+0.21)          Obsession - Opening Weekend (OBSSN.OW) 100000 5.42 (+0.42)          Verity (VERTY) 150000 46.50 (+0.21)          In the Grey - Opening Weekend (NGREY.OW) 100000 5.34 (+0.34)          Colony (CLONY) 150000 2.13 (+0.13)          Deep Water (DEEPW) 50000 5.91 (+1.00)          Angel and the Badman (ANBAD) 150000 11.27 (+1.27)          Deep Water (DEEPW) 150000 5.91 (+1.00)          Angel and the Badman (ANBAD) 150000 11.27 (+1.27)          The Isolate Thief (ISOLT) 150000 1.00 (0.00)          The Isolate Thief (ISOLT) 150000 1.00 (0.00)          Angel and the Badman (ANBAD) 150000 11.27 (+1.27)          The Isolate Thief (ISOLT) 150000 1.00 (0.00)          Untitled Kyoto Project (KYOTO) 50000 11.75 (-0.06)          A Tree is Blue (ATBLU) 49999 4.46 (-0.03)          Hot Spot (HTSPT) 49999 4.02 (-0.49)          Ty Simpkins (TSIMP) 25000 83.46 (-1.00)          Wicker (WCKER) 25000 5.92 (+0.05)          Cut Off (CUTOF) 1 39.77 (-0.17)          Cut Off (CUTOF) 150000 39.77 (-0.17)          A Place In Hell (APHEL) 1 8.82 (-0.02)          A Place In Hell (APHEL) 1 8.82 (-0.02)