Forum Discussion
Please help me succeed in stock trading!
Hello! I was hoping someone would be able to help me with this project. I am a beginner in excel and I was hoping someone can help me track the performance of stock symbols that I choose everyday and figure what works and what doesn’t over a long period of time.
Here’s how I think I can do it:
Everyday, I record stock symbols that I see attractive for an entry soon. These entries are either a BUY or a SELL. They can also be one of several patterns. What I try to do is to track these symbols over time and see if my theory worked or no, and hopefully generate some metrics that would help improve my trading strategy.
In this excel sheet I am trying to do this task by using the following entries. and here are also the adjustments that I need!
- Date: I was hoping that there’s a way that could auto generate today’s date once I click on the cell or some other way of making date entry convenient.
- Symbol: each day can have multiple symbols . Entries are ticker symbols like (AAPL, GE, etc..)
- Direction: each symbol can either be BUY or SELL - to be chosen from a drop down menu if possible
- Pattern: Patterns either belong to BUY or SELL directions. Each symbol can be one of the following patterns , to be chosen from a drop down menu . N.b.: no need to write buy/sell pattern on the actual entry
- Bull flag (buy pattern)
- Bear flag (sell pattern)
- Bottoming tail (b p)
- Topping tail (s p)
- Bullish engulfing (b p)
- Bearish engulfing (s p)
- Morning star (b p)
- Evening star (s p)
- Double bottom (b p)
- Double top (s p)
- Bullish piercing (b p)
- Bearish piercing (s p)
- Bullish kicker (b p)
- Bearish kicker (s p)
- Major trendline buy (b p)
- Major trendline sell (s p)
- Cup and handle (b p)
- Head and shoulders (s p)
- Bullish reversal (b p)
- Bearish reversal (s p)
- Bullish combo (buy pattern)
- Bearish combo (sell pattern)
5.Did it work? Yes (green colored) or No (red colored) Drop down menu - this is the end result of my theories , that I will enter after a couple weeks of observing the stock.
These are the metrics that I need to be populated MONTHLY, QUARTERLY, YEARLY and OVERALL (if possible!)
- Number and percentage of symbols that worked (from total symbols)
- Number and percentage of symbols that worked that are BUY direction (from total symbols that worked)
- Number and percentage of symbols that worked that are SELL direction (from total symbols that worked)
- Number and percentage of symbols that worked of EACH BUY pattern (from total symbols that worked that are BUY)
- Number and percentage of symbols that worked of EACH SELL pattern (from total symbols that worked that are SELL)
N.B: I have several stored symbols since March of 2023 that I would like to enter manually before I start the new ones.
And thank you so much!
For automating the date entry in Excel, you can use the formula "=TODAY()" in the date cell, and it will automatically fill in today's date. Regarding symbols, direction, and patterns, you're on the right track with drop-down menus for easy selection. Now, for those metrics, Excel can be a powerful tool. You can use functions like COUNTIF and COUNTIFS to calculate the number and percentages of symbols that worked, both overall and by direction or pattern. As you get more data, consider checking out Quantum AI for trading insights. It's a helpful addition to your trading toolkit.
Hi there. You can use the Data tab and select Download from Web. Also, you can use Power Query to download daily data. There are videos available on YouTube that will show you how to do this.
- I haven’t found anything that explains how to achieve these particular tasks. Please send any videos you think can address how to extract these metrics. Thanks!
Here is one about Power Query
Try using the help function to find out how to create drop down boxes and do simple data pulls from Yahoo finance..
The help function will be your friend as you learn how to use this tool.
Best of luck with your trade testing.
