Hi, Shrewd!        Login  
Shrewd'm.com 
A merry & shrewd investing community
Best Of MIBest OfAll BoardsThe Shrewd’m WeeklyLearn to InvestHow to Become Shrewd
Search
Shrewd'm.com Merry shrewd investors
Search
Best Of MIBest OfAll BoardsThe Shrewd’m WeeklyLearn to InvestHow to Become Shrewd


The week's question
In March 2025, in the thread "Re: OT, out", Umm asked the members: "Do you think it is because America is made up of magical soil that makes businesses based in America magically profitable?" This week it is put to everyone again. The button below opens the small thread re-asking it - read what others have said so far, then give your own answer as an ordinary reply.
Answer this questionContinue to Shrewd'mThis note won't appear again
Investment Strategies / Mechanical Investing
Unthreaded | Threaded | Whole Thread (7) |
Author: FlyingCircus ✧  😊 😞
Number: of 6243 
Subject: What's working lately research
Date: 07/08/24 11:53 PM
Post New | Post Reply | Report Post | Recommend It!
No. of Recommendations: 10
Team, I've started playing around with research into the possibility of tracking actual screen results over recent time periods using Google Sheets.

Very initial prototype can work, but unfortunately it's quite manual copy/pasting, data cleanup & text-to-columns at the moment. It would need some Sheets elbow grease and optimally someone who knows a few things about Google Scripting to create useful "macros". Otherwise it would be an hours-long manual exercise weekly (or monthly).

But if it worked - it would be available in real-time online, shared read-only to anyone interested.

Ideally it would report out a partial version of what Bill2m used to be able to generate:
                       screen    #_stocks  YTD   last_week                                 screen  #_stocks  trailing 12 months
Low_Mult__(SIPRO) 3 66% 11.4% Low_Mult__(SIPRO) 3 132%
SOS_A 3 55% 3.5% 3pt_Relative_Value__(SIPRO) 3 123%
OVER_PEG 3 54% 3.5% PEG13 3 123%

but without the advanced Excel VBA and local database / Windows code knowledge I assume that took, on top of both VL and SIPro weekly subscriptions.

Manlobbi, this is a stretch, but is it possible to enhance this site's code to allow the weekly screen picks post content to be characterized as a "table" for GoogleFinance's purposes? That would be a big accelerator, as then the formula function below would autopopulate a Sheet with screen picks filled in rows and columns:
=IMPORTHTML("elann writes on Rankings for 8Jul2024","table",1)

But I assume that's a fantasy because these posts are just text in, text out, not <td> as could come from a database server.
an example of one that is not protected and very useful: (but dear God it's PHP...)
etfscreen.com: etfscreen.com - etfscreen Resources and Information.

(Most paid websites are preventing that call from working by producing filter results either in a javascript object or some other non-html "table" display.)

Just spitballing,
FC
Post New | Post Reply | Report Post | Recommend It!
Print the post
Members reply directly to FlyingCircus here — and replies get answered. Reading is free; so is joining the conversation. Join Shrewd'm »
This community has written 6,224 posts about Mechanical Investing. The article-length ones it recommended most:
Dividend investing · 52 recs · 2025
Non-Mag7 screen · 34 recs · 2025
OT - Div yields and returns · 32 recs · 2024
Using AI to generate backtesting programs · 30 recs · 2025
Rankings for 19Dec2022 · 29 recs · 2022
Unthreaded | Threaded | Whole Thread (7) |


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 | Open Questions | Moving a community