HSX Forum

CelebStock and StarBonds

I pulled the calculation up to set the row colours. Looks like I introduced a bug. It's fixed now. {nm}

Posted by: elchan (a.k.a elchan2012) on Feb 07, 09:20 in response to elchan's post Hmm, WTF? The subtraction operator is broken? I'll have...

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. 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!


Digger - Opening Weekend (DIGER.OW) 100000 22.24 (-0.22)          Digger (DIGER) 150000 70.64 (-1.51)          David Harbour (DHARB) 25000 77.46 (0.00)          David Harbour (DHARB) 25000 77.46 (0.00)          Teenage Mutant Ninja Turtles (li (TMNT5) 150000 50.00 (0.00)          Dwayne Johnson (TROCK) 25000 148.81 (+1.00)          Dwayne Johnson (TROCK) 25000 148.81 (+1.00)          Lily James (LJAME) 25000 39.85 (-0.33)          Lily James (LJAME) 25000 39.85 (-0.33)          Josh Gad (JGAD) 25000 125.14 (-0.66)          Primetime - Opening Weekend (PRMTM.OW) 25000 12.05 (-0.16)          Josh Gad (JGAD) 25000 125.14 (-0.66)          King Conan (CONA2) 150000 57.26 (+1.47)          Kathryn Newton (KNEWT) 25000 92.18 (+0.50)          Kathryn Newton (KNEWT) 25000 92.18 (+0.50)          Jeremy Renner (JRENN) 25000 124.79 (-0.33)          Jeremy Renner (JRENN) 25000 124.79 (-0.33)          Resident Evil (RESE8) 25000 112.19 (+3.09)          Chris Evans (CEVAN) 25000 107.92 (-0.66)          Chris Evans (CEVAN) 25000 107.92 (-0.66)          Jesse Eisenberg (JEISE) 25000 47.75 (+0.33)          Jesse Eisenberg (JEISE) 25000 47.75 (+0.33)          Renate Reinsve (REREI) 25000 37.57 (+0.25)          Renate Reinsve (REREI) 25000 37.57 (+0.25)          David Harbour (DHARB) 25000 77.46 (0.00)          David Harbour (DHARB) 25000 77.46 (0.00)          Aaron Pierre (APIER) 25000 129.21 (-0.66)          Aaron Pierre (APIER) 25000 129.21 (-0.66)          Walton Goggins (WGOGG) 25000 7.84 (+0.15)          Walton Goggins (WGOGG) 25000 7.84 (+0.15)          Rashida Jones (RJONE) 25000 85.94 (+0.75)          Rashida Jones (RJONE) 25000 85.94 (+0.75)          Jodie Foster (JFOST) 25000 17.52 (+0.30)          Jodie Foster (JFOST) 25000 17.52 (+0.30)          Teenage Mutant Ninja Turtles (li (TMNT5) 150000 50.00 (0.00)          Beanie Feldstein (BFELD) 25000 37.13 (+0.25)          Digger - Opening Weekend (DIGER.OW) 25000 22.24 (-0.22)          Beanie Feldstein (BFELD) 25000 37.13 (+0.25)          Digger H$25 Put (DIGER.PU) 25000 3.68 (+0.26)          James Gray (JGRAY) 25000 15.32 (+0.10)          James Gray (JGRAY) 25000 15.32 (+0.10)          Jenna Ortega (JORTE) 25000 73.66 (0.00)          Jenna Ortega (JORTE) 25000 73.66 (0.00)          Jenna Ortega (JORTE) 25000 73.66 (0.00)          Helen Mirren (HMIRR) 25000 90.96 (-0.50)          Helen Mirren (HMIRR) 25000 90.96 (-0.50)          Spike Fearn (SFEAR) 25000 23.64 (-0.13)          Verity H$25 Call (VERTY.CA) 25000 3.13 (+0.10)          Verity - Opening Weekend (VERTY.OW) 25000 27.59 (-0.81)          Freddy the 13th (FREDY) 150000 52.43 (+0.87)