HSX Forum

CelebStock and StarBonds

Canadian Kaigee fans - I've had some success accessing the data on kaigee.com

Posted by: RogerMore on Sep 20, 08:12

1. Open a new spreadsheet in Google Sheets

2. in Cell A1 (or wherever) paste the following formula

=importhtml("https://www.kaigee.com/SBO/dROI/All","table",1)

3. Press enter and wait a few seconds for Google Sheets to scrape the data from kaigee.com

If you want to see the data from other pages on the website, change the website address used in the formula

Some other pages:

https://www.kaigee.com/SBO/ByAdjDate

https://www.kaigee.com/SBO/RecentAdjusts

https://www.kaigee.com/SBO/dROI/NextAdj

https://www.kaigee.com/SBO/dROI/90days

Ā 

If you want the website link for other pages at kaigee.com, I've been able to find them by looking in my internet history, and by using the Wayback Machine at archive.org





Post a Reply

To post to the forums you must first login!


Phantom Son (PHSON) 33000 7.99 (-0.06)          Avengers: Doomsday (AVNG5) 5000 526.64 (-0.22)          Backrooms $175M Blockbuster Warr (BACRM.BW) 832 5.00 (0.00)          Untitled A24 Horror Film aka Unt (UASTE) 50000 24.00 (-2.76)          Untitled A24 Horror Film aka Unt (UASTE) 150000 24.00 (-2.76)          Tomb Raider (TOMB4) 4 2.95 (+0.01)          The Man with the Bag (TMWTB) 65 7.80 (-0.01)          Tomb Raider (TOMB4) 4 2.95 (+0.01)          The Man with the Bag (TMWTB) 65 7.80 (-0.01)          The Memory Police (TMEMP) 20 4.06 (+0.07)          Top Gun 3 (TOPG3) 38 203.46 (-1.00)          Tower of Terror (TOWRT) 3 10.59 (+0.03)          Untitled A24 Horror Film aka Unt (UASTE) 100 24.00 (-2.76)          White Elephant (WELEP) 155 13.68 (-0.37)          John Wick: Chapter 5 (WICK5) 4 66.60 (-0.22)          John Wick Prequel (WICK0) 4 37.18 (-0.13)          What Happens At Night (WHANT) 3 46.70 (-0.03)          Wind of Change (WNDOC) 10 4.34 (+0.04)          Wind River: The Next Chapter (WNRV2) 30 2.28 (+0.06)          Wonder Woman (WOND3) 50 43.24 (-0.07)          Wonka 2 (WONK2) 65 56.62 (-0.22)          X-Men aka Mutants (XMEN8) 4 167.68 (+0.81)          Watch Dogs (WTDOG) 4 8.74 (+0.03)          Melissa Barrera (MBARR) 65 44.11 (0.00)          Toy Story 5 (TOYS5) 63763 432.57 (+7.12)          Jack Whitehall (JAWHI) 4 59.75 (-0.16)          Minions & Monsters - Opening (MNIO3.OW) 100000 79.60 (+0.85)          Minions & Monsters H$75 Call (MNIO3.CA) 25000 4.14 (+0.04)          Ruby Rose (RROSE) 5 81.42 (-0.25)          Ariana Grande (AGRAN) 7 170.66 (-0.99)          Julia Butters (JBUTT) 7 78.17 (-0.50)          Aaron Sorkin (ASORK) 8 14.81 (-0.10)          Milly Alcock (MALCO) 21 63.29 (-0.60)          Cate Blanchett (CBLAN) 14 13.76 (-0.19)          Backrooms $175M Blockbuster Warr (BACRM.BW) 25000 5.00 (0.00)          Claire Foy (CFOY) 51 9.62 (-0.15)          Claire Foy (CFOY) 98 9.62 (-0.15)          Michael Sarnoski (MSARN) 49 50.82 (-1.17)          The Six Billion Dollar Man (6MILL) 15 6.53 (+0.09)          A Head Full of Ghosts (AHFOG) 8 6.12 (+0.05)          Hello Kitty (HLOKT) 4 35.92 (+0.01)          Dynamic Duo (DYDUO) 5 119.92 (-0.48)          The Flood (FLOOD) 8 85.15 (+0.56)          Lice (LICE) 149999 5.95 (+0.16)          November 1963 (NOV63) 8 6.70 (-0.05)          Ray Gunn (RAYGN) 10 7.20 (+0.07)          The Lunar Chronicles (LUNAR) 15 57.21 (+7.21)          Untitled A24 Horror Film aka Unt (UASTE) 150000 24.00 (-2.76)          Lice (LICE) 150000 5.95 (+0.16)          The Lunar Chronicles (LUNAR) 1 57.21 (+7.21)