HSX Forum

CelebStock and StarBonds

Do you know any programming?

Posted by: edzep on Dec 16, 13:52 in response to Guillo's post Dude I will like to know how to do this.

KaiGee is using Excel macros written in Visual Basic. I use Javascript via GreaseMonkey in Firefox. There are many other scripting languages that may be appropriate.

The general idea is to open a web page into a memory buffer, in an XML encoded format. Then, code written specifically for the task is used to extract the desired data. The extracted data is then pasted into a spreadsheet, or built into an HTML page for display.

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!

Ads disabled on hsx.com


Lena Headey (LHEAD) 25000 7.84 (-6.63)          Lena Headey (LHEAD) 25000 7.84 (-6.63)          Lena Headey (LHEAD) 25000 7.84 (-6.63)          Jack Reynor (JREYN) 25000 17.36 (-0.93)          Jack Reynor (JREYN) 25000 17.36 (-0.93)          Jack Reynor (JREYN) 25000 17.36 (-0.93)          Jack Reynor (JREYN) 25000 17.36 (-0.93)          Daniel: The Fiery Furnace (DANIL) 150000 5.00 (0.00)          Peter Asher: Everywhere Man (PAEWM) 150000 0.60 (-0.40)          Octet (OCTET) 150000 21.55 (+1.55)          Tramell Tillman (TTILL) 25000 149.00 (0.00)          Daniel: The Fiery Furnace (DANIL) 23917 5.00 (0.00)          Daniel: The Fiery Furnace (DANIL) 150000 5.00 (0.00)          Star Wars: The Mandalorian and G (SWAR3) 150000 195.81 (-0.98)          Mortal Kombat II (MKMB2) 150000 99.43 (-1.91)          Power Ballad (PWRBL) 75000 16.04 (+0.18)          Slanted (SLANT) 150000 1.70 (-0.01)          Lena Headey (LHEAD) 25000 7.84 (-6.63)          Jack Ryan: Ghost War (RYAN1) 150000 6.81 (-1.26)          Anna Faris (AFARI) 25000 83.66 (+0.75)          Jack Ryan: Ghost War (RYAN1) 150000 6.81 (-1.26)          Ally (ALLY) 150000 21.63 (+1.21)          Olivia Holt (OHOLT) 25000 12.31 (-0.51)          Olivia Holt (OHOLT) 25000 12.31 (-0.51)          Scary Movie (SCAR6) 150000 80.48 (+1.54)          The Flood (FLOOD) 150000 69.32 (+1.45)          Lena Headey (LHEAD) 25000 7.84 (-6.63)          Lena Headey (LHEAD) 25000 7.84 (-6.63)          Tramell Tillman (TTILL) 25000 149.00 (0.00)          Rainbow Six (RNBW6) 150000 10.31 (-0.14)          Creed IV (CREE4) 150000 29.45 (-0.16)          Octet (OCTET) 150000 21.55 (+1.55)          Daniel: The Fiery Furnace (DANIL) 150000 5.00 (0.00)          Fuze (FUZE) 150000 3.84 (-0.14)          El Muerto (MUERT) 150000 3.73 (-0.06)          Constantine 2 (CNST2) 150000 33.97 (-0.13)          Ronan Boyle and the Bridge of Ri (RBOYL) 150000 11.01 (-0.11)          Cloverfield 2 (CLOV2) 150000 11.38 (-0.08)          Ebenezer: A Christmas Carol (EBNZR) 150000 81.02 (+0.33)          Theo James (TJAME) 25000 10.40 (-0.52)          Aladdin 2 (ALAD2) 150000 20.97 (-0.02)          Theo James (TJAME) 25000 10.40 (-0.52)          Tom and Jerry: Forbidden Compass (TMJR2) 150000 19.02 (-0.12)          World War Hulk (THLK2) 150000 31.95 (-0.08)          Rupert Friend (RFRIE) 25000 59.19 (+0.83)          John Wick: Chapter 5 (WICK5) 150000 67.92 (-0.29)          Rupert Friend (RFRIE) 25000 59.19 (+0.83)          Stephen Graham (SGRAH) 25000 87.99 (+0.26)          Andrea Riseborough (ARISE) 25000 3.71 (-0.20)          Kiersey Clemons (KCLEM) 25000 24.28 (+1.00)