HSX Forum

CelebStock and StarBonds

I have a SBO adjust spreadsheet that I might be willing to share also...

Posted by: KaiGee on Dec 14, 15:56 in response to edzep's post OK Starbond mavens, I have RogerMore's bond spreadsheet...

It relies completely on VB macros inside of excel and is very poorly (if at all) documented in the code.  Iirc, it doesn't use the XML feed either, it pulls almost all necessary data directly from HSX SBO, MST, and release date pages.  The only thing that needs to be done by hand is fixing a few times when a wide release movie delists before an earlier limited release movie.

My VB skills in excel are good (to toot my own horn) and I would be willing to help where possible also.  I have some extra free time since I lost most of previous stuff (boo hoo).

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!


Resident Evil (RESE8) 50000 49.53 (0.00)          The Napa Boys (NAPAB) 5047 0.47 (0.00)          Merlin (MERLN) 150000 0.07 (-0.02)          The Housemaid $100M Blockbuster (HMAID.BW) 25000 11.09 (-0.02)          Ready or Not 2: Here I Come (RONO2) 50000 31.63 (-0.07)          The Napa Boys (NAPAB) 99 0.47 (0.00)          The Bride! (BRIDE) 50000 44.83 (+0.22)          Merlin (MERLN) 150000 0.07 (-0.02)          Avatar: Fire and Ash $345M Block (AVAT3.BW) 25000 13.89 (+0.14)          The President's Cake (TPCAK) 200 0.20 (0.00)          Timothée Chalamet - Marty Supre (A6ATCH) 25000 9.92 (+0.06)          The Secret Agent - Picture (A6PTSA) 25000 0.57 (0.00)          Star Trek (TREK4) 150000 27.24 (+0.03)          Obsession (OBSSN) 50000 17.53 (+0.02)          The Secret Agent - Picture (A6PTSA) 25000 0.57 (0.00)          Teyana Taylor - One Battle after (A6STTA) 25000 10.28 (+0.14)          Star Trek (TREK4) 150000 27.24 (+0.03)          Sinners - Original Screenplay (A6OSIN) 25000 11.17 (+0.07)          Psycho Killer (PSYKL) 50000 7.65 (+0.02)          The President's Cake (TPCAK) 99 0.20 (0.00)          One Battle After Another - Pictu (A6POBA) 25000 9.51 (+0.03)          Sean Penn - One Battle after Ano (A6RSPE) 25000 9.23 (+0.03)          Paul Thomas Anderson - One Battl (A6DPTA) 25000 11.19 (+0.07)          One Battle After Another - Adapt (A6EOBA) 25000 10.58 (0.00)          Michael B. Jordan - Sinners - Ac (A6AMBJ) 25000 6.56 (+0.03)          Marty Supreme - Original Screenp (A6OMSU) 25000 3.89 (+0.03)          Psycho Killer (PSYKL) 50000 7.65 (+0.02)          Leonardo DiCaprio - One Battle a (A6ALDC) 25000 5.16 (-0.01)          Melania (MLNIA) 150000 14.59 (-0.29)          Josh Safdie - Marty Supreme - Di (A6DJSA) 25000 2.12 (0.00)          Reading Lolita in Tehran (RLITA) 1984 0.58 (+0.01)          Hamnet - Picture (A6PHAM) 25000 0.51 (-0.02)          Hamnet - Adapted Screenplay (A6EHAM) 25000 2.23 (0.00)          Frankenstein - Picture (A6PFRN) 25000 0.78 (-0.06)          Star Trek (TREK4) 150000 27.24 (+0.03)          F1 - Picture (A6PF1) 25000 0.22 (-0.04)          Shiver (SHVER) 150000 61.35 (-2.80)          Reading Lolita in Tehran (RLITA) 505 0.58 (+0.01)          Ryan Gosling (RGOSL) 10000 128.90 (+0.80)          The Custom of the Country (TCOTC) 150000 18.88 (+2.21)          Fantasy Life (FNTLF) 996 0.09 (-0.01)          Fantasy Life (FNTLF) 404 0.09 (-0.01)          Jump Street: Now For Her Pleasur (21JS3) 189 0.06 (-0.01)          Jump Street: Now For Her Pleasur (21JS3) 299 0.06 (-0.01)          28 Years Later: The Bone Temple (28LT4) 150000 28.49 (-0.17)          The Custom of the Country (TCOTC) 150000 18.88 (+2.21)          Starship Troopers (STRPR) 10000 40.50 (+0.63)          John Wick: Chapter 5 (WICK5) 103658 108.44 (+1.36)          The Raid (RAID1) 901 0.07 (+0.02)          The Raid (RAID1) 999 0.07 (+0.02)