HSX Forum

CelebStock and StarBonds

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

Posted by: elchan (a.k.a elchan2012) on Feb 07, 08:54 in response to DTravel's post From my experience creating my spreadsheet -

from the securities page.  The problem with the TAG in the securities page is that it is always lagging the bond's price and the expected tag.  Just adding another TAG value could make the table confusing.  If other would weight in on it's usefulness, or lack thereof, I would appreciate it.

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!


Teenage Mutant Ninja Turtles (li (TMNT5) 2000 50.00 (0.00)          Teenage Mutant Ninja Turtles (li (TMNT5) 119118 50.00 (0.00)          Teenage Mutant Ninja Turtles (li (TMNT5) 100000 50.00 (0.00)          Teenage Mutant Ninja Turtles (li (TMNT5) 150000 50.00 (0.00)          Beware Boiuna (BOUNA) 2000 19.47 (-0.12)          Beware Boiuna (BOUNA) 1000 19.47 (-0.12)          Angel and the Badman (ANBAD) 2000 10.84 (-0.62)          Angel and the Badman (ANBAD) 2000 10.84 (-0.62)          Copperhead (COPRH) 2000 16.78 (-1.39)          Copperhead (COPRH) 2000 16.78 (-1.39)          Teenage Mutant Ninja Turtles (li (TMNT5) 150000 50.00 (0.00)          From the World of John Wick: Cai (FJWCN) 150000 45.03 (-0.14)          Highlander (HIGHL) 150000 41.54 (-0.38)          Christmas At The Kringles (CKRNG) 1000 8.50 (+0.04)          Copperhead (COPRH) 1000 16.78 (-1.39)          Teenage Mutant Ninja Turtles (li (TMNT5) 100000 50.00 (0.00)          Daniel and The Fiery Furnace (DANIL) 149912 7.09 (+2.16)          The Social Reckoning (SOCI2) 182 55.15 (-1.80)          Coyote vs. ACME (CVACM) 120000 50.85 (-0.64)          Daniel and The Fiery Furnace (DANIL) 105000 7.09 (+2.16)          Digger H$25 Call (DIGER.CA) 25000 1.44 (+0.10)          Digger H$25 Put (DIGER.PU) 25000 3.75 (+0.33)          Teenage Mutant Ninja Turtles (li (TMNT5) 150000 50.00 (0.00)          Artist in Residence (ARTIR) 150000 0.02 (+0.01)          Jacob Elordi (JELOR) 25000 20.41 (-0.25)          Ridley Scott (RSCOT) 25000 62.81 (+0.50)          Shaun The Sheep: The Beast Of Mo (SHEP3) 150000 6.24 (-1.82)          Nicole Kidman (NKIDM) 25000 56.65 (-0.66)          Nicole Kidman (NKIDM) 25000 56.65 (-0.66)          Nicole Kidman (NKIDM) 25000 56.65 (-0.66)          Nicole Kidman (NKIDM) 25000 56.65 (-0.66)          Teenage Mutant Ninja Turtles (li (TMNT5) 2000 50.00 (0.00)          Teenage Mutant Ninja Turtles (li (TMNT5) 150000 50.00 (0.00)          Honeymoon/Funeral (HNYMF) 150000 5.77 (-0.23)          Bad Apples (BAPPL) 150000 1.12 (-0.02)          Practical Magic 2 (PRAC2) 150000 71.17 (-1.92)          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)