HSX Forum

CelebStock and StarBonds

From my experience creating my spreadsheet -

Posted by: DTravel on Feb 07, 08:43 in response to elchan's post It's variance with a sample size of 1. Ok, I'll change...

RogerMore is right about needing the current TAG for double-checking.Ā  If your calculated current TAG differs from HSX's current TAG, then you need to check your own math and that can find problems with other calculations.

You also need it because movies can continue to report BO after their stock here delists and that changes the current TAG.

My bond adjust table adjust table indicates some very nice returns available for next week. {nm} elchan Feb 06, 21:39

MSCHO: 7.93% dROI, for small ports, and MCOTI: 4.72% for larger ports. elchan Feb 06, 21:41

Aiiiieeeeeeee!!! Bright colors! Could you got with more pastel shades of green and red to not fry our eyes? :) {nm} BSmurf Feb 07, 06:51

Working on it, dude, but I'm colour challenged. {nm} elchan Feb 07, 07:00

Please don't get me wrong: I think this is fantastic work you're doing. I was just being silly about the colors, though they were generally BSmurf Feb 07, 08:45

Hmm, WTF? The subtraction operator is broken? I'll have to check this. {nm} elchan Feb 07, 09:03

I pulled the calculation up to set the row colours. Looks like I introduced a bug. It's fixed now. {nm} elchan Feb 07, 09:20

Color scheme is looking better now - thanks. {nm} RogerMore Feb 07, 14:03

Like it is now, or when it was red and white, like the Canadian flag? {nm} elchan Feb 07, 16:16

Now. Before, it was "Aaagh, my eyes". I'd probably prefer the ticker symbol text to be black though - it would stand out more {nm} RogerMore Feb 07, 16:33

Text are all in black, except the links. Links have to be a different colour. {nm} elchan Feb 07, 18:47

What do the numbers in the "Variance" column mean? They seem to be completely random, yet look to be the determiner of red or green rows, BSmurf Feb 07, 06:58

Just the difference between price and TAG. Negative and red means the calculated TAG is lower the current price. {nm} elchan Feb 07, 07:01

The calculations are wrong though. I wouldn't call it variance either, as that has a different meaning in statistics RogerMore Feb 07, 07:56

It's variance with a sample size of 1. Ok, I'll change the column to "Change". elchan Feb 07, 08:30

From my experience creating my spreadsheet - DTravel Feb 07, 08:43

I'll have to think on that. My TAG calculation has enough smarts to detect if the movie is delisted and chooses the Gross instead price... elchan Feb 07, 08:54





Post a Reply

To post to the forums you must first login!


When We Pray (WPRAY) 2495 0.01 (-0.01)          World War Hulk (THLK2) 150000 32.35 (-0.26)          Mortal Kombat II (MKMB2) 10000 99.10 (+0.57)          Her Private Hell (HERPH) 150000 5.98 (+0.05)          Animal Farm (AFARM) 150000 8.93 (-0.77)          Hey Joe (TUMIA) 10000 0.01 (-0.03)          Hey Joe (TUMIA) 106 0.01 (-0.03)          Nimrods aka New Years Rev (NIMRD) 30000 5.34 (+1.15)          Nimrods aka New Years Rev (NIMRD) 10000 5.34 (+1.15)          Her Private Hell (HERPH) 150000 5.98 (+0.05)          Her Private Hell (HERPH) 150000 5.98 (+0.05)          Sniff (SNIFF) 506 0.01 (-0.01)          Heart Eyes 2 (HRTE2) 1000 19.26 (+0.16)          Sniff (SNIFF) 8397 0.01 (-0.01)          Angel and the Badman (ANBAD) 150000 11.66 (-1.50)          The Kidnapping of Arabella (TKOAR) 150000 1.00 (0.00)          Angel and the Badman (ANBAD) 10000 11.66 (-1.50)          Angel and the Badman (ANBAD) 10000 11.66 (-1.50)          The Kidnapping of Arabella (TKOAR) 150000 1.00 (0.00)          The Wrong Girls (TWRNG) 5000 8.94 (-0.63)          A Colt Is My Passport (ACIMP) 150000 8.00 (0.00)          Panopticon (PANOP) 1798 0.01 (0.00)          X-Men aka Mutants (XMEN8) 3000 162.54 (-0.73)          A Colt Is My Passport (ACIMP) 150000 8.00 (0.00)          Mob Girl (MOBGR) 406 0.01 (0.00)          Rolling Loud (RLOUD) 10000 9.15 (-0.81)          A Colt Is My Passport (ACIMP) 150000 8.00 (0.00)          The Kidnapping of Arabella (TKOAR) 150000 1.00 (0.00)          Mob Girl (MOBGR) 9993 0.01 (0.00)          Black Panther 3 (BPNT3) 5000 223.07 (-0.76)          Black Panther 3 (BPNT3) 4000 223.07 (-0.76)          Jump Street: Now For Her Pleasur (21JS3) 505 0.01 (0.00)          Jump Street: Now For Her Pleasur (21JS3) 8497 0.01 (0.00)          Hey Joe (TUMIA) 15494 0.01 (-0.03)          The Wrong Girls (TWRNG) 5000 8.94 (-0.63)          Star Wars: Starfighter (SWAR4) 26944 248.78 (+0.93)          ABC: RJ Decker (RJDECK) 4 9.00 (+0.04)          Deep Water (DEEPW) 20000 5.74 (-0.31)          ABC: RJ Decker (RJDECK) 4 9.00 (+0.04)          Animal Farm (AFARM) 150000 8.93 (-0.77)          Animal Farm (AFARM) 1 8.93 (-0.77)          Patrick Stewart (PSTEW) 25000 58.75 (-0.50)          Miami Vice '85 (MIVIC) 5000 96.32 (+0.25)          Iman Vellani (IVELL) 25000 34.80 (-0.38)          The Super Mario Galaxy Movie $39 (MARI2.BW) 25000 9.74 (+0.47)          Romy & Michelle 2 (ROMY2) 150000 14.05 (-0.25)          The Chosen Season 6 (TCS61) 150000 12.63 (-0.23)          Hot Spot (HTSPT) 90000 4.52 (+0.51)          Tuner (TUNER) 150000 4.17 (-0.17)          The Devil Wears Prada 2 (PRAD2) 150000 224.06 (-2.79)