Morning stock signal: buy, hold or sell

Every morning the scenario gathers financials and news per stock, two AI models reach an agreed verdict, the result is logged to таблица and sent to Microsoft Teams.

  • Financials and news per stock are gathered automatically
  • Two AI models, with a tiebreaker on disagreement
  • Risk assessment and a technicals check
  • A ready signal in Microsoft Teams every morning
Google SheetsFmp

How it works

To move data from Microsoft Teams to Google Sheets automatically, use a ready-made scenario — no manual exports.

  1. Starts when: Schedule Trigger
  2. Then: FMP_Stock_Screener
  3. Then: Score_and_Prefilter
  4. Then: Write_Scan_Opportunities
  5. Check: loop_over_tickers
  6. Then: Build Summary
  7. Then: Send a text message
  8. Then: Seekingalpha Articles
  9. Then: Clean the news
  10. Check: If1
  11. If yes: XML
  12. Then: Edit Fields2
  13. Then: Final version of news
  14. Check: Merge1
  15. Then: First round ChatGPT
  16. Then: Clean Up ChatGPT
  17. Check: Merge
  18. Then: Clean Up Results from First Round
  19. Check: Needs Tiebreaker?
  20. If yes: Tide Breaker - Bull
  21. Then: Clean up Chatgpt 2
  22. Check: Merge6
  23. Then: TideBreaker Cleanup
  24. Check: Merge7
  25. Check: If
  26. If yes: Get Previous Verdict
  27. Then: Thesis Reversal Enricher
  28. Then: Alert Filter
  29. Check: If Alert?
  30. If yes: Get Price History
  31. Then: Consolidate price history
  32. Then: Get Earnings
  33. Then: Technical & Earnings Enricher
  34. Then: Risk_Manager
  35. Check: Above 50MA & SELL?
  36. If yes: Telegram Alert
  37. Check: Is Thesis Reversal?
  38. If yes: Thesis Reversal Alert
  39. Then: Log_Signal_Outcome
  40. If no: Above 50MA and BUY?
  41. If no: Watchlist Telegram
  42. Then: write_sentiment_to_sheets
  43. Then: Wait
  44. If yes: Tide Breaker - Bear
  45. Then: Clean up Gemini 2
  46. If no: No Tidebreaker
  47. Then: First round Gemini
  48. Then: Clean up Gemini
  49. If no: return the news
  50. Then: FMP - Profile
  51. Then: Clean Profile
  52. Check: Merge3
  53. Check: Merge2
  54. Check: Merge4
  55. Check: Merge66
  56. Check: Merge77
  57. Check: Merge88
  58. Check: Merge99
  59. Then: Clean Read Financial
  60. Then: FMP - Income Statement
  61. Then: Aggregate1
  62. Then: Clean Income statement
  63. Then: FMP - CashFlow
  64. Then: Aggregate2
  65. Then: Clean Ccashflow
  66. Check: Merge5
  67. Then: FMP- Current Price
  68. Then: Clean Current Price
  69. Then: FMP - Balance Sheet Quarter
  70. Then: Aggregate
  71. Then: Clean balance quarter sheet
  72. Then: FMP - Income Statement annual
  73. Then: Clean Income statement annual
  74. Then: FMP - Balance Sheet Annual
  75. Then: Clean balance sheet Annual
  76. Then: FMP - CashFlow Annual
  77. Then: Clean Ccashflow Annual
  78. Then: FMP - Key Metrics TTM
  79. Then: FMP - Key Metrics TTM1

You can launch this Microsoft Teams + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.