Hi, Shrewd!        Login  
Shrewd'm.com 
A merry & shrewd investing community
Best Of MI | Best Of | Favourites & Replies | All Boards | Post of the Week!
Search MI
Shrewd'm.com Merry shrewd investors
Best Of MI | Best Of | Favourites & Replies | All Boards | Post of the Week!
Search MI


Investment Strategies / Mechanical Investing
Unthreaded | Threaded | Whole Thread (13) |
Author: FlyingCircus   😊 😞
Number: of 3957 
Subject: Re: Retrieving Historical price Data
Date: 03/10/2025 11:19 PM
Post New | Post Reply | Report Post | Recommend It!
No. of Recommendations: 5
I assume better options are now available, Some sites are simply member gating everything.

An example: BC's extensive data tables used to be simply scrapable using googlesheets importhtml command. As were Stockcharts' charts; they were even accessible in Excel integrations.

Those sites have put their table content and chart content behind javascript objects that aren't reachable by any of the basic tools I'm aware of.

The only way I can get BC PAMA data is with a basic account; I literally hit the link to get the table response and then click in one very specific location, drag down through the 3 months of data rows (only and no further), copy & paste into a Sheet (which doesn't understand it's in columns), and wrote a Gscript (macro lite) to copy / transpose paste every 7 rows in to one row with 6 columns. I do this once per PAMA period (10,20, etc.), once a week. If I paid for a premium account I could download & import these but...

Yes I'm cheap and still working fulltime and not interested in buying Pinnacle data.

Thank the "charity" of etfscreen.com for leaving their tables open in html, which is why I still give them a donation every year.

FC
Post New | Post Reply | Report Post | Recommend It!
Print the post
Unthreaded | Threaded | Whole Thread (13) |


Announcements
Mechanical Investing FAQ
Contact Shrewd'm
Contact the developer of these message boards.

Best Of MI | Best Of | Favourites & Replies | All Boards | Followed Shrewds