[Gemini × GAS × Free] AI Stock Analysis App ①
Theme: A stock analysis app that uses Gemini to analyze corporate disclosure information
Requirements: Google account (free version is fine)
API key for Google AI Studio, etc. (free version is fine, but paid is even better)
Final Output: Spreadsheet output
What is a personal utility app?
It is an app that utilizes Google services like Spreadsheets, GAS, and Gemini to reduce daily manual tasks.
Based on the premise of "Looks are secondary, as long as it works! (But I won't compromise on the content!)",
👉 I prioritize using my time for the things I want to do afterward.
Trial and error as a retail investor and the challenge of automation
I'm Natsu, a novice investor who started trading stocks with the new NISA (lol).
I'm exploring my own investment style, thinking about how to make my daily stock trading more efficient.
When I first started, I just diligently checked SBI Securities tools, charts, and timely disclosures (TDnet), but recently I've been using a custom app that links generative AI with Google Apps Script (GAS) to organize information.
I'm improving the accuracy of my analysis by automating the retrieval of stock prices for stocks I'm interested in and summarizing vast amounts of disclosure documents.
App operation concept
①Timely disclosure information (TDnet) Retrieve information for the day
② Send analysis instructions to Gemini API for each company
③ Output AI analysis results to a spreadsheet
④ Update PTS night-time session stock prices at 30-minute intervals (spreadsheet output)
It's very helpful because it explains "This company's stock price will go up!" with reasons. After all, I want to buy with conviction, right!
The daily report is automatically created around 7:00 PM. It would probably be best to run it at 10-minute intervals after the market opens (9:00 AM on weekdays), but I can't watch it while I'm at work anyway (lol).
At first, I was analyzing in the browser, but it was hard to request for each company one by one, so the API became the main method. But I still do browser analysis quite a bit because it's easy to read.
There is also the hallucination problem, so it's even better to get a second opinion from other APIs like ChatGPT.
Unfortunately, the free version of the Gemini API is currently capped at gemini-1.5-flash-preview, and gemini-1.5-pro etc. cannot be used. If I realize the usefulness of this app, I think I will consider the paid version.
※ Actually, I don't have enough funds to trade much (lol)
Output image
