HSX Forum

CelebStock and StarBonds

Which one? Multiple tabs or with the comparison to purchase price? {nm}

Posted by: elchan (a.k.a elchan2012) on Apr 21, 16:02 in response to Panachevitz's post I have the same issue as PVL.

@elchan, your port checker isn't working. Looks like the quantity held is slipped one column. Also, when it was "working" the green/red PVL Admin Apr 20, 14:16

Working fine for me, and I'm not seeing any errors from others. Make sure that the format is correct. It is based on purch price and adj. elchan Apr 20, 14:59

Used to work. Since Portmonkey changes, it does not....for me. PVL Admin Apr 20, 16:13

Just tried it with portmonkey. EXACT same results as without. {nm} PVL Admin Apr 20, 16:17

Figured out the issue - you need to fix something. When I cut/paste my port directly into your input, it is tab separated. PVL Admin Apr 20, 16:28

also, the green ain't right. Current price 58. Adjust price 51. position is LONG. Green. Not right. Should be red as in, not making $$ {nm} PVL Admin Apr 20, 16:29

The regex is supposed to replace the tabs with one space. I'll check on that. But the check is based on purch price, not current price. elchan Apr 20, 17:46

Why would you base it on purchase price. If i hold long enough, the current price could go past adjust and I would be holding wrong. PVL Admin Apr 20, 23:14

Yes, but for it to drop from 51 to 49 means there's a flip in position, due to the fact that the next adjust will drop the bond's TAG... elchan Apr 21, 08:12

Also another argument for my method is that it's kinda irrelevant what the current price is ... elchan Apr 21, 08:59

Totally disagree... I'll try to explain better PVL Admin Apr 21, 10:36

If it shoots past the next TAG then the bond is over bought. This means that you are making more money ... elchan Apr 21, 12:00

I'm not saying your POV is wrong, just I have to choose a health criterion, maybe someone can suggest a way I can represent both situations. {nm} elchan Apr 21, 12:17

But what happens when it goes PAST the intended adjust point, but still is going to adjust. It will still show green even though I am PVL Admin Apr 21, 10:23

Answered above ... {nm} elchan Apr 21, 12:01

Also. for maximum benefit/usage, you really need a way to remove the zero box office movies from the next adjust. {nm} PVL Admin Apr 21, 10:41

Yes this makes sense. Was meaning to do it, and just did. (Added an SQL clause to exclude movies with 0 gross as reported by HSX) elchan Apr 21, 12:16

I don't know what you mean by 'regular search', but comparison of purchase price and expected TAG is useless. not2fast Apr 23, 10:38

If you're not aware, I have a web site which presents bond tags, pre-calculated in table form. Here are the links: elchan Apr 23, 17:16

I have the same issue as PVL. {nm} Panachevitz Apr 21, 13:38

Which one? Multiple tabs or with the comparison to purchase price? elchan Apr 21, 16:02

The original technical problem, tab issues with importing data into the spreadsheet. {nm} Panachevitz Apr 21, 18:16

I made a change an just tested it with a port monkey copy&paste. See if it's improved. elchan Apr 22, 07:54

nope, still won't add in the position held column, which is filled by the quantity. Panachevitz Apr 22, 19:39

The port monkey support is limited, because it colour codes the position. You will not get an assessment. elchan Apr 22, 23:29

Hope this helps. Firefox is problematic (not port monkey). Explorer works fine PVL Admin Apr 23, 10:49

That helps. I need to add to the regex to replace all multiple spaces with one space. Thanks! {nm} elchan Apr 23, 20:54

Yep, I made the change and now multiple spaces and tabs should work. elchan Apr 23, 21:04

It works and looks beautiful! Thanks! :D {nm} Panachevitz Apr 23, 21:35

What is a port checker? Can I get a link please? {nm} Rigit Apr 23, 09:55

Here's the link to the port checker: elchan Apr 23, 17:11





Post a Reply

To post to the forums you must first login!


Gundam (GUNDM) 100000 6.07 (+4.56)          Gladiator II (GLAD2) 150000 188.83 (-1.24)          Grendel (GREND) 150000 20.78 (+0.78)          Blade (BLAD1) 30000 81.01 (+3.32)          Smile 2 (SMIL2) 50000 60.03 (+0.22)          The Running Man (TRUNM) 150000 62.65 (+0.84)          Grendel (GREND) 150000 20.78 (+0.78)          Top Gun 3 (TOPG3) 12500 242.39 (-0.92)          Grendel (GREND) 150000 20.78 (+0.78)          Masters of the Universe (HEMAN) 10000 57.61 (+0.35)          Masters of the Universe (HEMAN) 100000 57.61 (+0.35)          Blood on Snow (BLOSN) 49999 26.87 (-0.19)          The Smashing Machine (SMACH) 49999 15.22 (-0.08)          Absolution (THUG) 150000 2.72 (-0.11)          Den of Thieves 2: Pantera (DENO2) 100000 24.66 (+0.15)          Absolution (THUG) 150000 2.72 (-0.11)          Mission: Impossible 8 (MISS8) 10000 152.54 (-0.43)          The Map that Leads to You (TMTLY) 50000 17.23 (+0.58)          The Map that Leads to You (TMTLY) 150000 17.23 (+0.58)          Grendel (GREND) 85000 20.78 (+0.78)          Song Sung Blues (SSBLU) 50000 19.84 (-0.54)          Song Sung Blues (SSBLU) 150000 19.84 (-0.54)          Werewolves (WEREW) 55000 24.39 (-0.10)          Super Toys (SPTOY) 100000 15.08 (+0.14)          Spinal Tap II (STAP2) 49999 20.00 (-0.11)          Look Who's Talking (LWTLK) 49999 4.00 (+0.03)          Supergirl: Woman of Tomorrow (SUPGR) 50000 75.78 (+0.89)          Supergirl: Woman of Tomorrow (SUPGR) 150000 75.78 (+0.89)          Aaron Sorkin (ASORK) 1000 19.91 (+0.10)          The Drama (TDRAM) 50000 20.38 (+1.25)          The Drama (TDRAM) 1 20.38 (+1.25)          Gundam (GUNDM) 150000 6.07 (+4.56)          Gundam (GUNDM) 150000 6.07 (+4.56)          Gundam (GUNDM) 10000 6.07 (+4.56)          Blade (BLAD1) 150000 81.01 (+3.32)          Supergirl: Woman of Tomorrow (SUPGR) 150000 75.78 (+0.89)          Voltron (VOLTN) 6 66.20 (+0.36)          Zatanna (ZATAN) 3 8.15 (+0.02)          The Legend of Zelda (ZELDA) 3 118.96 (-0.11)          Zatanna (ZATAN) 3 8.15 (+0.02)          Here - Opening Weekend (HERE1.OW) 100000 14.10 (-0.18)          The Legend of Zelda (ZELDA) 3 118.96 (-0.11)          The Legend of Zelda (ZELDA) 3 118.96 (-0.11)          Here H$20 Call (HERE1.CA) 25000 0.19 (+0.08)          New York Will Eat You Alive aka (ZMBRO) 1200 1.46 (-0.03)          Here - Opening Weekend (HERE1.OW) 100000 14.10 (-0.18)          Dua Lipa (DLIPA) 35 95.63 (0.00)          Emma Corrin (EMCOR) 3 93.97 (-0.25)          Jaume Collet-Serra (JCSER) 39 84.78 (-0.25)          Diego Calva (DCALV) 3999 6.30 (-0.05)