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


Investment Strategies / Mechanical Investing
Unthreaded | Threaded | Whole Thread (16) |
Author: FlyingCircus   😊 😞
Number: of 5383 
Subject: Re: Signals
Date: 01/13/26 10:09 PM
Post New | Post Reply | Report Post | Recommend It!
No. of Recommendations: 6
For "a while" now, most websites have made it so that the only way you can grab data is to put the cursor in the first cell of the table, and click-drag down & across to the lower right of the table, keeping the cursor in the last cell of the table, ctrl-c or edit/copy, then pick a cell in your spreadsheet of choice and either paste, or paste-special values.

This is because they present (bury) the data in the response inside of javascript objects, so older & simpler methods like Excel's query/html or Google Sheets' IMPORTHTML table just get nothing.

With Barcharts, getting historical data added another tedious step - pasting puts every cell in one column. I had to write a gscript in Chrome's macro module to then parse each cell value into a 7 column wide row.

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


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