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 December 2024, in the thread "Re: BRK: Why Not XOM?", BreckHutHigh asked the members: "What about the long road trips with kids?" 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 (2) |
Author: mungofitch 🐝🐝🐝 GOLD
SHREWD
  😊 😞

Number: of 6131 
Subject: Re: Value Line Inv. Survey - Newbie question
Date: 06/14/26 5:56 PM
Post New | Post Reply | Report Post | Recommend It!
No. of Recommendations: 13
It is traditionally a bit difficult to create the picks for any but the very simplest screens directly from the web interface. I haven't tried in so long that I can't help you on that front.

But this is the other way to do it, traditional in MI circles:

Check to see if your subscription allows you to use their Windows software.
Its name changes from time to time, it used to be the Value Line Investment Survey for Windows, then Value Line Investment Analyzer.
This is the page with the download link, which may work if you're logged in.
Value Line: Value Line

Again, assuming your subscription supports it, you can download the weekly update files for that program.
This is the page that has the most recent update files.
Value Line: Value Line

So, if your subscription supports those two things (and you're running Windows!) you can do everything from there.

Download and install the latest weekly update, normally posted early Monday mornings.
Start the Windows program.
When it prompts for log-on, choose "work off line"
Click: Summary and Index | Value Line Screens | Value Line Investment Survey 1700 Stocks | Display
File | Export | Spreadsheet
On the dialog box, check "export headings", export what=all, format=tab delimited, click OK
It will warn you that there are too many columns for Excel, click OK
Enter a file name | Save

That gives you a tab delimited file with ALL the fields in the database, up to date.
There are lots of ways to use this, but one traditional way is to run the magical Excel macro which creates the picks for any screen you like, given its definition in the "Radiscript" language.
(ongoing thanks to the GreatRadish, RIP)

Though I often just use the Unix "cut" comment to pull up the fields I want into a narrower CSV file and import the fields of interest into Excel, then sort.

Jim

Post New | Post Reply | Report Post | Recommend It!
Print the post
Members reply directly to mungofitch here — and replies get answered. Reading is free; so is joining the conversation. Join Shrewd'm »
This community has written 6,115 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 (2) |


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