HSX Forum

CelebStock and StarBonds

I'm not saying that I do it, I'm saying that my VB macros do it. And it not quite thousands of pages.

Posted by: KaiGee on Dec 15, 14:21 in response to edzep's post What what?

8 to get all of the MST with release dates

~275 MST pages to find the associated SBO

~675 SBO pages to find the MST in their TAGs

~200 MST pages that may still be making money

OK, maybe 1k.

It only takes about an hour for everything to run.  I just have to start the macros and do some slight adjusting for some wide/limited release date mixups.  Probably actually only about 15-20 minutes a week of actual work on my part.

I probably average 2-3k page hits a week.  Good weeks probably push 10k or more.  I've had discussions with HSX and this topic has never come up.  I'm sure they like the page hits, the advertisers don't know that no one is actually looking at the pages.

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!


The Dog Stars (DOGST) 1 47.84 (-2.70)          Coyote vs. ACME (CVACM) 100001 45.19 (+1.04)          The Dog Stars H$20 Call (DOGST.CA) 25000 1.09 (0.00)          Lesbian, Gay, Bisexual and Trans (LGBTQ) 20000 20.00 (0.00)          Scapegoat (SCAPG) 149999 21.02 (+1.02)          Coyote vs. ACME (CVACM) 149900 45.19 (+1.04)          Alice Eve (AEVE) 25000 8.22 (-0.06)          The Dog Stars H$20 Put (DOGST.PU) 25000 3.43 (+0.33)          Cooper Hoffman (CHOFF) 25000 12.79 (+0.21)          Evil Dead Wrath (EVLD7) 150000 34.71 (+0.02)          Chase Sui Wonders (CSWON) 25000 15.01 (+0.20)          Cooper Hoffman (CHOFF) 25000 12.79 (+0.21)          Destin Daniel Cretton (DDCRE) 25000 105.76 (+0.50)          Michael 2 (MJAC2) 6593 186.64 (+0.68)          Cooper Hoffman (CHOFF) 25000 12.79 (+0.21)          Zendaya (ZENDA) 25000 169.62 (+36.79)          Christopher Miller (CMILL) 25000 190.09 (0.00)          Ving Rhames (VRHAM) 25000 152.65 (-1.40)          Bingbing Fan (FBING) 25000 96.35 (+0.25)          50 Cent Curtis Jackson (50CEN) 25000 48.85 (-0.16)          Martin Campbell (MCAMP) 25000 32.99 (-0.12)          Robert Rodriguez (RRODR) 25000 19.67 (+0.10)          Jessie Buckley (JSBUC) 25000 9.86 (+0.07)          In the Hand of Dante (ITHOD) 150000 0.10 (-0.02)          David Harbour (DHARB) 25000 76.97 (+0.50)          Sally Hawkins (SHAWK) 25000 50.09 (+0.16)          Sally Hawkins (SHAWK) 25000 50.09 (+0.16)          Pierre Morel (PMORE) 25000 45.54 (+0.16)          Pierre Morel (PMORE) 25000 45.54 (+0.16)          Tom Holland (TOHOL) 25000 182.33 (+25.63)          Shirley MacLaine (SMACL) 25000 37.25 (+0.12)          Shirley MacLaine (SMACL) 25000 37.25 (+0.12)          Gal Gadot (GGADO) 25000 99.72 (0.00)          Gal Gadot (GGADO) 25000 99.72 (0.00)          Emma Mackey (EMACK) 25000 55.05 (0.00)          Emma Mackey (EMACK) 25000 55.05 (0.00)          Jacob Batalon (JBATA) 25000 107.84 (-1.15)          Brendan Gleeson (BGLEE) 25000 15.50 (0.00)          Charli XCX (CXCX) 25000 1.71 (-2.54)          Sadie Sink (SSINK) 25000 71.25 (+1.61)          Brendan Gleeson (BGLEE) 25000 15.50 (0.00)          John Cho (JCHO) 25000 15.02 (-0.10)          Awkwafina (AWKWA) 25000 115.07 (-0.33)          Awkwafina (AWKWA) 25000 115.07 (-0.33)          Eli Roth (EROTH) 25000 30.57 (-0.37)          Eli Roth (EROTH) 25000 30.57 (-0.37)          Street Fighter (STFTR) 7109 82.84 (+0.75)          Sofia Vergara (SVERG) 25000 79.13 (-0.50)          Sofia Vergara (SVERG) 25000 79.13 (-0.50)          F.A.S.T. (FAST) 150000 50.68 (+0.02)