Whats up! I hoped somebody would have the ability to assist me with this mission. I’m a newbie in excel and I hoped somebody may help me observe the efficiency of inventory symbols that I select on a regular basis and determine what works and what doesn’t over an extended time period.
Right here’s how I feel I can do it:
On a regular basis, I file inventory symbols that I see enticing for an entry quickly. These entries are both a BUY or a SELL. They can be considered one of a number of patterns. What I attempt to do is to trace these symbols over time and see if my principle labored or no, and hopefully generate some metrics that will assist enhance my buying and selling technique.
On this excel sheet I’m making an attempt to do that job through the use of the next entries. and listed below are additionally the changes that I would like!
- Date: I hoped that there’s a manner that would auto generate at this time’s date as soon as I click on on the cell or another manner of constructing date entry handy.
- Image: every day can have a number of symbols . Entries are ticker symbols like (AAPL, GE, and so forth..)
- Course: every image can both be BUY or SELL – to be chosen from a drop down menu if attainable
- Sample: Patterns both belong to BUY or SELL instructions. Every image will be one of many following patterns , to be chosen from a drop down menu . N.b.: no want to jot down purchase/promote sample on the precise entry
- Bull flag (purchase sample)
- Bear flag (promote sample)
- Bottoming tail (b p)
- Topping tail (s p)
- Bullish engulfing (b p)
- Bearish engulfing (s p)
- Morning star (b p)
- Night star (s p)
- Double backside (b p)
- Double prime (s p)
- Bullish piercing (b p)
- Bearish piercing (s p)
- Bullish kicker (b p)
- Bearish kicker (s p)
- Main trendline purchase (b p)
- Main trendline promote (s p)
- Cup and deal with (b p)
- Head and shoulders (s p)
- Bullish reversal (b p)
- Bearish reversal (s p)
- Bullish combo (purchase sample)
- Bearish combo (promote sample)
5.Did it work? Sure (inexperienced coloured) or No (purple coloured) Drop down menu – that is the tip results of my theories , that I’ll enter after a pair weeks of observing the inventory.
These are the metrics that I must be populated MONTHLY, QUARTERLY, YEARLY and OVERALL (if attainable!)
- Quantity and proportion of symbols that labored (from whole symbols)
- Quantity and proportion of symbols that labored which might be BUY path (from whole symbols that labored)
- Quantity and proportion of symbols that labored which might be SELL path (from whole symbols that labored)
- Quantity and proportion of symbols that labored of EACH BUY sample (from whole symbols that labored which might be BUY)
- Quantity and proportion of symbols that labored of EACH SELL sample (from whole symbols that labored which might be SELL)
N.B: I’ve a number of saved symbols since March of 2023 that I want to enter manually earlier than I begin the brand new ones.
And thanks a lot!
