HSX Forum

CelebStock and StarBonds

OK Starbond mavens, I have RogerMore's bond spreadsheet file available...

Posted by: edzep on Dec 14, 15:39

It's a formidable piece of work. Note that it is a 2.5 MB zip file, yielding a spreadsheet file of about 11 MB. To use it effectively beyond Dec. 14, you would need to gain access to the XML data that HSX can provide.

Internal documentation appears good. I will follow this post with the overview notes that RogerMore included in the email to me. Certainly a good bit of study will be in order. It looks like there are some opportunities for streamlining the update steps, for macro/VB programmers. (I haven't touched that stuff in about 7 years, and would have to dig out an old copy of Excel to try my macro skillz; currently using OpenOffice and Gnumeric.)

The download link is at the bottom of my Port Monkey page. I hope we don't have 400 people downloading it, as that will bust the monthly bandwidth cap for my free account.

OK Starbond mavens, I have RogerMore's bond spreadsheet file available... edzep Dec 14, 15:39

Overview notes from RogerMore edzep Dec 14, 15:42

where can I get a copy of the spreadsheet? {nm} RazorHawk Dec 14, 16:39

edzep has a link in his original post {nm} RogerMore Dec 14, 16:52

thanks, got confused on thought it was on his league page (uses same name) {nm} RazorHawk Dec 14, 16:59

I have some questions about the spreadsheet. Guillo Dec 14, 20:08

There is a lot of manual input and I've talked about it in detail in other posts on this board {nm} RogerMore Dec 14, 20:56

I find the sheet to be impressive. Hard to fully appreciate withouth XML to run through it. edzep Dec 15, 11:23

A week without updates won't matter so much. A month without updates will - too many changes in price, attachments, release dates, etc RogerMore Dec 15, 11:50

I have a SBO adjust spreadsheet that I might be willing to share also... KaiGee Dec 14, 15:56

Will like to give it a look if you don't mind. {nm} Guillo Dec 14, 20:10

What what? edzep Dec 15, 11:28

Since they took away the XML feeds from the non-priveledged players, it's the only way to gather the needed information. shadowking Dec 15, 12:14

I'm not saying that I do it, I'm saying that my VB macros do it. And it not quite thousands of pages. KaiGee Dec 15, 14:21

Dude I will like to know how to do this. Guillo Dec 16, 06:20

Do you know any programming? edzep Dec 16, 13:52

I know basic programing and can hold my own in excel pretty well. Guillo Dec 16, 18:49

Shoot me off an email, and I'll see what I can do for you... KaiGee Dec 16, 20:54

shadowking and KaiGee edzep Dec 15, 15:20

you guys are doing a great job etc etc. jane_citizen Dec 14, 17:43

ditto {nm} Ramdadof3 Dec 15, 04:32

you do know that my spreadsheet (which Roger helped create) is in the zip file I posted, right? {nm} ProjectGenome Dec 15, 09:36

Yes, though I did not know that initially. edzep Dec 15, 11:16

XML ProjectGenome Dec 15, 13:38





Post a Reply

To post to the forums you must first login!


Johnny Knoxville (JKNOX) 25000 15.56 (+0.37)          Mark Ruffalo (MRUFF) 25000 73.61 (+13.72)          The Thing That Hurts (TTTHU) 150000 1.15 (-0.02)          Kyle Gallner (KGALL) 25000 35.64 (-0.04)          Naughty (NAUTY) 3000 41.33 (-0.20)          Day Drinker (DRNKR) 150000 16.13 (+0.14)          Ocean's 14 (OCEN6) 150000 86.39 (+1.93)          Jon Bernthal (JBERN) 25000 122.20 (+42.64)          Doctor Strange 3 (DRST3) 150000 68.83 (+1.10)          Resident Evil (RESE8) 2957 80.56 (+1.14)          Jessie Buckley (JSBUC) 12303 9.86 (+0.07)          Daveed Diggs (DDIGG) 25000 71.46 (-7.64)          Naruto (NARUT) 150000 36.87 (+0.25)          Scapegoat (SCAPG) 150000 21.07 (+1.07)          Longlegs 2 (LNLE2) 3000 54.93 (-0.04)          Destin Daniel Cretton (DDCRE) 25000 105.76 (+0.50)          F.A.S.T. (FAST) 35964 50.53 (-0.13)          Forgotten Island (FRGIS) 150000 63.02 (-1.68)          Forgotten Island (FRGIS) 150000 63.02 (-1.68)          Charli XCX (CXCX) 25000 1.71 (-2.54)          Lesbian, Gay, Bisexual and Trans (LGBTQ) 19208 20.00 (0.00)          Longlegs 2 (LNLE2) 150000 54.93 (-0.04)          Longlegs 2 (LNLE2) 150000 54.93 (-0.04)          Charli XCX (CXCX) 25000 1.71 (-2.54)          Insidious: Out of the Further (NSID6) 150000 48.72 (-2.64)          Grandgear (GGEAR) 3000 56.94 (-0.14)          Insidious: Out of the Further (NSID6) 150000 48.72 (-2.64)          Insidious: Out of the Further (NSID6) 8798 48.72 (-2.64)          Scapegoat (SCAPG) 150000 21.07 (+1.07)          Margie Claus (MARGC) 150000 36.90 (+0.22)          Spider-Man: Brand New Day $855M (SPID9.BW) 25000 6.33 (+0.65)          The Brigands of Rattlecreek (BRGND) 150000 27.62 (+1.99)          Street Fighter (STFTR) 12891 82.84 (+0.75)          Doctor Strange 3 (DRST3) 150000 68.83 (+1.10)          Babies (BBIES) 150000 17.11 (+2.06)          Tony (TONY) 150000 15.22 (-0.75)          Tony (TONY) 150000 15.22 (-0.75)          4 x 4: The Event (4X4TE) 150000 9.04 (+0.13)          Last Night At The Lobster (LNATL) 150000 3.67 (-0.06)          Last Night At The Lobster (LNATL) 150000 3.67 (-0.06)          The Thing That Hurts (TTTHU) 150000 1.15 (-0.02)          The Island (ISLAN) 150000 0.30 (+0.04)          The Graveyard Book (GRVBK) 150000 0.21 (-0.02)          Doctor Strange 3 (DRST3) 150000 68.83 (+1.10)          Bad Blood (BDBLD) 150000 0.02 (0.00)          Bad Blood (BDBLD) 150000 0.02 (0.00)          Mutiny (MUTNY) 150000 16.86 (+0.57)          Lesbian, Gay, Bisexual and Trans (LGBTQ) 20000 20.00 (0.00)          Sense and Sensibility (SNSNS) 10000 22.49 (+0.09)          Insidious: Out of the Further (NSID6) 150000 48.72 (-2.64)