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 (2) |
Post New
Author: Dog_Island_Inv_Co   😊 😞
Number: of 5822 
Subject: Value Line Inv. Survey - Newbie question
Date: 06/14/26 3:59 PM
Post Reply | Report Post | Recommend It!
No. of Recommendations: 4
I have a 2 week VLIS trial underway, and I'm trying to export data to work with in a spreadsheet.

Specifically, I've opened the VL "Stock Screener", selected the data fields used in the CashCowROE Screen, and now I'm trying to export the data into a spreadsheet, so I can create a calculated column (ROE multiplied by Div Yield), on the way to the MI screen itself.

The AI Overview feature of Google search tells me I should be able to export using the "Export Results" or "Export as Port. CSV" buttons. However, I don't see any such buttons in the VL interface I'm looking at. The only actions made available are displayed on a line as below:

Stock Screener | Reset Criteria | Open Saved Screen |Update Screen | Create Saved Screen | Delete Screen

Sorry to be such a newbie, but can anyone steer me in the right direction?

Thanks!

Robert Marshall
Print the post


Author: mungofitch SILVER
SHREWD
  😊 😞

Number: of 5822 
Subject: Re: Value Line Inv. Survey - Newbie question
Date: 06/14/26 5:56 PM
Post Reply | Report Post | Recommend It!
No. of Recommendations: 12
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.
https://www3.valueline.com/analyzer

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.
https://www3.valueline.com/analyzer/archive/std

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

Print the post


Post New
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