HSX Forum

CelebStock and StarBonds

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

Posted by: BSmurf on Feb 07, 08:45 in response to elchan's post Working on it, dude, but I'm colour challenged.

too strong/bright to be able to read the numbers easily.

As for the "Change" column (as it's now called), the numbers are incorrect.

Example: HMIRR - price: $18.21; projected adjust TAG: $14.11; The change should be $4.11. You have -28.04.

Many (most) of the "Change" column are way off like this, and it will be confusing for some people.

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 Odyssey (ODYSE) 300 310.18 (-1.90)          The Face of Horror (FCOHR) 1301 9.13 (+0.01)          Paddington 4 (PADT4) 150000 25.00 (0.00)          Minions & Monsters (MNIO3) 300 311.12 (-2.26)          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)