
Clive Thompson
チャンネル登録者数 3.27万人
1.3万 回視聴 ・ 1104いいね ・ 2025/06/21
In this video I show you how to use artificial intelligence (AI) to pick stocks.
Picking a portfolio of amazing stocks to beat the benchmark used to take me weeks. Now AI can do it for me in under an hour.
You can do it to. My full prompt is below. Just copy and paste it into your favourite AI tool, or modify it to reflect your own wishes:
PROMPT
You are a professional investment analyst. Your task is to identify 10 top-tier global stocks from different countries and industries using real, up-to-date financial data, strict quantitative filters, performance ranking, and qualitative review.
Your audience is a sophisticated investor. Do not ask the user any questions — instead, proceed autonomously and deliver a downloadable Excel spreadsheet with all required data and insights.
Geographic Scope
Limit the universe to companies headquartered in:
North America
Europe (including the UK and Scandinavia)
South Africa
Japan
Hong Kong
Singapore
Australasia
Switzerland
Step 1: Screening – Generate 7 Lists
Unless otherwise noted, include only companies with a market cap ≥ $10 billion (or equivalent).
List 1:
Forward P/E less than 25x
Forecast sales growth greater than 5% per year (3-year CAGR)
List 2:
EPS growth forecast greater than 25% CAGR (3 years)
Debt-to-equity = 0
List 3:
Price-to-sales less than 4x
Insider buying, greater than 70%
List 4:
Dividend yield greater than 4%
Price-to-book less than 1x
List 5:
PEG ratio less than 2
Profit margin greater than 20%
List 6:
Price-to-free-cash-flow less than 15x
Dividend growth forecast greater than 4% annually
List 7:
Market cap greater than $2 billion and less than $20 billion
P/E less than 15x
EPS growth forecast greater than 15% CAGR (3 years)
Step 2: Merge and Rank
1. Combine all 7 lists into one “All Stocks” list (remove duplicates).
2. Rank by share price performance since Jan 1, 2025 → take top 15 → Shortlist A
3. Rank by share price performance since Apr 1, 2025 → take top 15 → Shortlist B
4. Merge A and B into one “Shortlist” (remove duplicates)
5. Sort Shortlist by forecast sales growth (1Y) descending
Step 3: Final List of 10 Stocks
From the Shortlist:
Select up to 10 companies with unique country + industry combinations
Label this the Final List
Step 4: Real Data Collection Requirements
You must use only actual, real financial data and share prices — absolutely no fictional or illustrative figures. Proceed as follows:
1. Cross-verify each metric from at least 2 reputable sources, such as:
Yahoo Finance
MarketWatch
Morningstar
Company filings (10-K, annual reports, investor relations sites)
Bloomberg (if accessible)
IEX Cloud, Alpha Vantage, or equivalent API services
2. All prices, ratios, performance metrics, and volumes must be from real markets.
3. Clearly ensure that exchange rates, local currencies, and valuations are correctly normalized where applicable.
4. Use the latest available financials for 2024 and and Q1 2025 or H1 2025 if available.
5. For prices, use:
31 December 2024 closing price
1st April 2025 closing price
20 June 2025 closing price
Include these closing prices on the Excel Spreadsheet.
Step 5: Excel Spreadsheet Output
Create a downloadable Excel spreadsheet (.xlsx) with one row per stock and the following columns (include both quantitative and qualitative insights):
Column Data Description
A Name of the stock
B Main stock exchange
C Ticker symbol
D Home country
E Industry
F Number of employees
G Average daily volume (shares)
H Average daily volume (USD equivalent)
I Share price on 31st December 2024
J Share price on 20th June 2025
K Forecast sales growth (1Y)
L Forecast sales growth (3Y)
M EPS growth forecast (1Y)
N EPS growth forecast (3Y)
O Forward P/E
P Forward Price-to-Sales (P/S)
Q Forward Price-to-Book (P/B)
R Forward Price-to-Free Cash Flow (P/FCF)
S PEG ratio
T Profit margin
U Dividend yield
V Forecast dividend growth
W Debt-to-equity ratio
X Free cash flow per share (next 12 months)
Y Current share price (with date)
Z Forecast share price (12–24 month target)
AA Buy/Hold/Sell recommendation
AB Key positives and risks (1–2 paragraphs)
AC Recent developments (management, legal, product news) (1–2 paragraphs)
AD AI exposure and expectations (1–2 paragraphs)
Add additional columns with other relevant financial information.
Final Output Instructions
Complete all steps without further user input.
Do not use placeholder, estimated, or illustrative values.
Clearly label the source for each metric (in Excel comments or separate tab if needed).
Ensure the final output is formatted professionally, with columns A to AD populated.
Deliver the result as a downloadable Excel file (.xlsx), ready for review and action.
You may proceed now.
END OF PROMPT
I've been investing for 50 years. I've made a lot of mistakes. I've learned from my misakes. I try not to make the same mistakes twice.
コメント
使用したサーバー: directk
コメントを取得中...