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!


Paddington 4 (PADT4) 100000 25.00 (0.00)          Teyana Taylor (TETAY) 25000 44.20 (+0.30)          The Odyssey (ODYSE) 150000 310.18 (-1.90)          Latchkey Kids (LTCHK) 150000 0.01 (-0.03)          Latchkey Kids (LTCHK) 150000 0.01 (-0.03)          Monopoly (MONOP) 150000 10.99 (+0.76)          Monopoly (MONOP) 150000 10.99 (+0.76)          Young Washington (YWASH) 150000 33.38 (-0.57)          Paddington 4 (PADT4) 25000 25.00 (0.00)          The Odyssey (ODYSE) 150000 310.18 (-1.90)          Paddington 4 (PADT4) 150000 25.00 (0.00)          Deathstroke & Bane (DSTRK) 150000 62.24 (-7.52)          The Angry Birds Movie 3 (ANGR3) 5000 38.68 (+0.88)          Paddington 4 (PADT4) 150000 25.00 (0.00)          Dinner With Audrey (DWAUD) 150000 3.81 (-0.02)          Deathstroke & Bane (DSTRK) 12500 62.24 (-7.52)          Deathstroke & Bane (DSTRK) 150000 62.24 (-7.52)          Flesh of the Gods (FLOTG) 150000 9.20 (-0.03)          Scary Movie H$105M Blockbuster W (SCAR6.BW) 25000 6.11 (+1.11)          Deathstroke & Bane (DSTRK) 150000 62.24 (-7.52)          Paddington 4 (PADT4) 150000 25.00 (0.00)          Club Kid (CLUBK) 150000 13.59 (-0.06)          Monopoly (MONOP) 150000 10.99 (+0.76)          Monopoly (MONOP) 150000 10.99 (+0.76)          Tadanobu Asano (TASAN) 25000 90.29 (+0.25)          Katie Holmes (KHOLM) 2999 18.85 (0.00)          La Bola Negra aka The Black Ball (LBNEG) 150000 0.84 (-0.16)          Katie Holmes (KHOLM) 9993 18.85 (0.00)          Paddington 4 (PADT4) 150000 25.00 (0.00)          Paul Rudd (PRUDD) 25000 53.05 (-0.50)          Paul Rudd (PRUDD) 25000 53.05 (-0.50)          Oasis Live '25 (OASIS) 500 14.76 (-0.18)          Toy Story 5 (TOYS5) 150000 422.48 (-1.13)          Patrick Stewart (PSTEW) 25000 45.54 (+0.16)          Deathstroke & Bane (DSTRK) 100 62.24 (-7.52)          Patrick Stewart (PSTEW) 25000 45.54 (+0.16)          Paddington 4 (PADT4) 150000 25.00 (0.00)          The Angry Birds Movie 3 (ANGR3) 149948 38.68 (+0.88)          Lice (LICE) 150000 6.32 (+0.50)          Lice (LICE) 150000 6.32 (+0.50)          Wonder Woman (WOND3) 1 42.99 (-0.35)          Paddington 4 (PADT4) 150000 25.00 (0.00)          Paddington 4 (PADT4) 150000 25.00 (0.00)          Toy Story 5 (TOYS5) 99 422.48 (-1.13)          Lice (LICE) 150000 6.32 (+0.50)          Lice (LICE) 150000 6.32 (+0.50)          Mckenna Grace (MCGRA) 25000 63.17 (0.00)          Deathstroke & Bane (DSTRK) 150000 62.24 (-7.52)          Deathstroke & Bane (DSTRK) 150000 62.24 (-7.52)          Paddington 4 (PADT4) 150000 25.00 (0.00)