HSX Forum

CelebStock and StarBonds

It's variance with a sample size of 1. Ok, I'll change the column to "Change".

Posted by: elchan (a.k.a elchan2012) on Feb 07, 08:30 in response to RogerMore's post The calculations are wrong though. I wouldn't call it...

But, I disagree with the need for the current TAG, since it is not relevant.  The important thing is what the bond is trading at and what the exepected future tag is.  I do agree that the TAG should be labelled as "Calculated TAG".  Thanks for the input.

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 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)          Twilight of the Dead (TWOTD) 25000 3.70 (+0.69)