🪄 Activepieces Stock Market Analyst Bot: Automate Investment Research with Real-Time Data & AI-Powered Reports

Return only a boolean value: true or false. Determine whether the following query mentions a stock ticker symbol or company name related to the stock market.

Query:
{{trigger['message']['text']}}

Extract the stock ticker symbol from the following query. Respond with only the ticker symbol—no explanations, no extra text.

query:
{{trigger['message']['text']}}

Latest company overview for {{extracted_ticker}} include company profile, industry, sector, CEO, headquarters location, employee count, market capitalization and stock ticker symbol.

Extract latest financial performance data for {{extracted_ticker}}, including Revenue (TTM), Net Income (TTM), Year-over-Year revenue growth, gross margin, and recent quarterly trends

Identify 3-5 peer companies in the same sector as {{extracted_ticker}}. Extract key metrics such as P/E ratio, revenue, stock price, and market cap.

Include latest current price with %daily change, volume, 52-week high/low, P/E ratio, EPS, dividend yield, and chart data for 1D, 5D, 1M, YTD, and 1Y for {{extracted_ticker}}

Fetch latest finanical news for {{extracted_ticker}}. Include Earnings, Analyst Ratings, Market Moves, Partnerships, and Legal/Regulatory.

Compile a comprehensive investment report for **{{extracted_ticker}}**, formatted as a single HTML email body. Synthesize the outputs of all tasks: company overview, financial performance, competitive benchmarking, real-time stock snapshot, and categorized financial news.

The report must include the following structured sections:
1. **Quick Summary**  
   A concise AI-generated summary of {{extracted_ticker}} (e.g., "Apple is a global tech leader…").
2. **Company Profile Table**  
   Industry, Sector, CEO, HQ Location, Employees, Market Cap.
3. **Financial Performance Table**  
   Revenue (TTM), Net Income (TTM), YoY Growth, Gross Margin. Include a short narrative on key trends below the table.
4. **Competitive Benchmarking Table**  
   Compare {{extracted_ticker}} against 3–5 peers using: P/E, Revenue, Stock Price, Market Cap.
5. **Real-Time Stock Snapshot**  
   Include: Price, % Change, Volume, 52-week High/Low, P/E, EPS, Dividend Yield. Present chart summaries for 1D, 5D, 1M, YTD, and 1Y as plain text descriptions or inline image URLs (if available).
6. **Categorized Financial News**  
   Include 5 categories:  
   - Earnings  
   - Analyst Ratings  
   - Market Moves  
   - Partnerships  
   - Legal/Regulatory  
   Tag each news item with sentiment: 🟢 Positive, 🟡 Neutral, 🔴 Negative.
7. **Insight Section**  
   Write 2–3 paragraphs with:  
   - What’s going on with {{company_name}}  
   - Why it matters  
   - Outlook (*clearly labeled as not financial advice*)

**Important formatting instructions**:
- Use semantic HTML (e.g., `<h2>`, `<table>`, `<p>`)
- Apply all styles via **inline CSS only**
- Ensure all links are clickable (`<a href="...">`)
- Keep it responsive and compatible with major email clients (no JavaScript, no external assets)
- Don't include ```html in the output.

All the related information is below:

{{company_overview_response}}

{{financial_performance_response}}

{{peer_comparison_response}}

{{stock_snapshot_response}}

{{news_response}}

{{email_sender_address}}

{{trigger['message']['from']['value'][0]['address']}}

Stock Market Analysis of {{extracted_ticker}}

{{investment_report_html}}