HSX Forum

CelebStock and StarBonds

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,

Posted by: BSmurf on Feb 07, 06:58 in response to elchan's post My bond adjust table adjust table indicates some very...

based on whether they are positive or negative numbers. Unfortunately, the red or green row is not indicative of whether the stock will adjust up or down. That's confusing for Starbond newbies or those who don't want to do the work themselves.

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!


4 Kids Walk Into a Bank (4KWIB) 150000 6.45 (+0.30)          Colin Hanks (CHANK) 25000 57.74 (-0.16)          Anything But Ghosts (ANYBG) 150000 24.86 (+0.41)          Scary Movie H$105M Blockbuster W (SCAR6.BW) 25000 6.10 (+1.10)          Astaire (ASTAI) 150000 7.71 (+0.15)          Supergirl (SUPGR) 150000 104.68 (-1.62)          The Worst (TWORS) 150000 7.50 (+0.23)          The Angry Birds Movie 3 (ANGR3) 50000 38.45 (+0.65)          Michael Sarnoski (MSARN) 25000 50.17 (-0.16)          The Angry Birds Movie 3 (ANGR3) 50000 38.45 (+0.65)          Matthew Lillard (MLILL) 25000 81.58 (+0.50)          Matthew Lillard (MLILL) 25000 81.58 (+0.50)          The Angry Birds Movie 3 (ANGR3) 50000 38.45 (+0.65)          Frank Grillo (FGRIL) 25000 57.69 (+0.16)          The Angry Birds Movie 3 (ANGR3) 50000 38.45 (+0.65)          Frank Grillo (FGRIL) 25000 57.69 (+0.16)          La Bola Negra aka The Black Ball (LBNEG) 150000 0.79 (-0.21)          The Angry Birds Movie 3 (ANGR3) 50000 38.45 (+0.65)          Hugh Jackman (HJACK) 25000 72.46 (+0.50)          The Angry Birds Movie 3 (ANGR3) 50000 38.45 (+0.65)          Sinqua Walls (SWALL) 25000 13.79 (+0.20)          Sinqua Walls (SWALL) 25000 13.79 (+0.20)          John Magaro (JMAGA) 25000 3.26 (+0.05)          Werwulf (WERWU) 50000 75.81 (+2.30)          Werwulf (WERWU) 50000 75.81 (+2.30)          La Bola Negra aka The Black Ball (LBNEG) 150000 0.79 (-0.21)          Werwulf (WERWU) 50000 75.81 (+2.30)          Masters of the Universe (HEMAN) 100000 61.42 (-0.67)          Werwulf (WERWU) 50000 75.81 (+2.30)          Nick Jonas (NJONA) 25000 65.34 (-0.50)          Supergirl (SUPGR) 100000 104.68 (-1.62)          Andy Serkis (ASERK) 25000 109.74 (-0.66)          Nick Jonas (NJONA) 25000 65.34 (-0.50)          Werwulf (WERWU) 50000 75.81 (+2.30)          The Last Druid (TLDRU) 150000 7.15 (+0.34)          Scarlett Johansson (SJOHA) 499 68.66 (-0.25)          Werwulf (WERWU) 50000 75.81 (+2.30)          Deathstroke & Bane (DSTRK) 150000 63.05 (-6.71)          Disclosure Day (SKIES) 50000 103.57 (+1.05)          Andrea Riseborough (ARISE) 25000 5.62 (+0.15)          Hershey (HERSH) 150000 13.25 (+0.79)          Hershey (HERSH) 150000 13.25 (+0.79)          Joe Taslim (JTASL) 25000 105.66 (+0.34)          Untitled A24 Horror Film aka Unt (UASTE) 150000 29.96 (+1.63)          Colin Firth (CFIRT) 25000 58.12 (0.00)          Meryl Streep (MSTRE) 25000 144.62 (-0.66)          Meryl Streep (MSTRE) 25000 144.62 (-0.66)          Steven Spielberg (SSPIE) 25000 38.92 (-0.10)          Werwulf (WERWU) 50000 75.81 (+2.30)          Charli XCX (CXCX) 24993 24.43 (0.00)