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!


The Hunger Games: Sunrise on the (HGAM6) 20000 208.10 (-1.03)          The Gallerist (GALRS) 150000 6.31 (+1.21)          The Hunger Games: Sunrise on the (HGAM6) 40000 208.10 (-1.03)          The Hunger Games: Sunrise on the (HGAM6) 20000 208.10 (-1.03)          The Cat in the Hat (TCATH) 2023 80.62 (-2.62)          The Cat in the Hat (TCATH) 150000 80.62 (-2.62)          Jack Black (JBLAC) 5100 150.44 (-0.60)          Paul Mescal (PMESC) 4000 39.96 (+0.02)          Clayface (CLAYF) 150000 60.65 (+0.79)          Steve Buscemi (SBUSC) 25000 10.67 (-0.01)          Steve Buscemi (SBUSC) 25000 10.67 (-0.01)          Doctor Caligari’s Cabinet of W (DCCOW) 50000 17.95 (+0.36)          Dragon (DRAGO) 150000 6.47 (+0.80)          Doctor Caligari’s Cabinet of W (DCCOW) 50000 17.95 (+0.36)          Doctor Caligari’s Cabinet of W (DCCOW) 50000 17.95 (+0.36)          Doctor Caligari’s Cabinet of W (DCCOW) 50000 17.95 (+0.36)          Doctor Caligari’s Cabinet of W (DCCOW) 50000 17.95 (+0.36)          Doctor Caligari’s Cabinet of W (DCCOW) 50000 17.95 (+0.36)          Constantine (CNST2) 150000 33.31 (-0.44)          Constantine (CNST2) 150000 33.31 (-0.44)          King (KING) 50000 3.65 (+0.42)          King (KING) 50000 3.65 (+0.42)          King (KING) 50000 3.65 (+0.42)          Father Joe (FTJOE) 150 7.09 (+0.26)          King (KING) 50000 3.65 (+0.42)          King (KING) 50000 3.65 (+0.42)          King (KING) 50000 3.65 (+0.42)          A Head Full of Ghosts (AHFOG) 50000 4.35 (+0.43)          A Head Full of Ghosts (AHFOG) 50000 4.35 (+0.43)          A Head Full of Ghosts (AHFOG) 50000 4.35 (+0.43)          A Head Full of Ghosts (AHFOG) 50000 4.35 (+0.43)          The Asian Fund (ASIAN) 20000 20.44 (+0.09)          Magic: The Gathering (MGCTG) 150000 36.44 (+0.22)          A Head Full of Ghosts (AHFOG) 50000 4.35 (+0.43)          Magic: The Gathering (MGCTG) 150000 36.44 (+0.22)          A Head Full of Ghosts (AHFOG) 50000 4.35 (+0.43)          John Wick Prequel (WICK0) 150000 31.57 (+0.45)          Father Joe (FTJOE) 50000 7.09 (+0.26)          Father Joe (FTJOE) 50000 7.09 (+0.26)          Father Joe (FTJOE) 50000 7.09 (+0.26)          Father Joe (FTJOE) 50000 7.09 (+0.26)          Father Joe (FTJOE) 50000 7.09 (+0.26)          Father Joe (FTJOE) 50000 7.09 (+0.26)          Turpentine (TURPN) 50000 7.23 (+0.24)          Turpentine (TURPN) 50000 7.23 (+0.24)          Clayface (CLAYF) 1 60.65 (+0.79)          Turpentine (TURPN) 50000 7.23 (+0.24)          Turpentine (TURPN) 50000 7.23 (+0.24)          Clayface (CLAYF) 149999 60.65 (+0.79)          Turpentine (TURPN) 50000 7.23 (+0.24)