The MLB playoffs are approaching and I have created a template for you to track the games and also make predictions. The playoff picture and standings are as of today’s date, Sept. 26. However, I will update them at the end of the season and make any necessary changes, if necessary. This is how the template currently looks like:
If you don’t want to wait for my updated file and the standings do change, you can adjust them yourself. Next to the playoff tree, there is a section where you can update the seeding and wild card positions.
The division winners are highlighted in blue for the American League and red for the National League. The seeding will determine who plays who in the template.
As for making predictions, simply enter the number of games you are predicting each team to win. The team with more games will highlight in green as the winner, and they will be displayed as the team that advances to the next round. Since there is no re-seeding that takes place, the bracket remains unchanged.
This template can be useful if you want to make predictions with your friends and compare how you did. You can just create copies of each person’s predictions and then compare how you did at the end of the playoffs.
If you liked this Free 2025 MLB Playoff Template for Excel, please give this site a like on Facebook and also be sure to check out some of the many templates that we have available for download. You can also follow me on Twitter and YouTube. Also, please consider buying me a coffee if you find my website helpful and would like to support it.
The NFL season is approaching and I have created a free template in Excel that will make it easy to keep track of your favorite teams. You can also use it to make predictions and compete against your friends and colleagues. Here’s a look at how the template works.
Updating scores, the schedule, and your time zone
On the Master.Schedule tab, you’ll see a list of games for the NFL season. As the games are played, this is where you can update the scores. You can also update the schedule. Currently the Week 18 schedule is still to be determined, and while the matchups are known, the dates and times of those games won’t be set until towards the end of the season, after Week 17.
There is a time field showing when all the games are scheduled, which by default is set to ET. However, if you’re in a different time zone you can select your preferred time zone from the drop-down option on the left. You can change to PT, MT, or CT.
If your time zone isn’t listed here, then you can delete the selection, and change the time zone in the GMT offset section below:
This value will only apply if the preferred time zone is cleared out. After updating your time zone settings, you’ll see that in the Your Local Time field, the time of the games will be updated to reflect your local time zone.
You can also specify a watchlist of teams you’re interested in following. You can select multiple teams, and upon doing so, the schedule will update to highlight the games they are involved in:
Viewing a complete schedule for a full team
If you just want to track the games involving a specific team, you can do that on the Team.Schedule tab. From the drop-down on the left-hand side, you can select the team you’re interested in, and their schedule will update, including their bye week.
This page is formatted to make it easy to print out on a single sheet of paper, in landscape mode.
Viewing the full week schedule
If you prefer to see the list of games for the full week, you can utilize the Weekly.Schedule tab to do that. Similar to the team tab, here you’ll update the week with the Week number. You can also use the watchlist to track teams you are interested in, just as on the Master.Schedule tab.
Viewing the entire NFL season on a grid format
On the Schedule.Grid tab, you have a list of the entire games by team, for the entire season. Here, you can see the opponents they are playing, as well as their bye weeks.
There are also different settings you can apply, such as a watchlist to show any key matchups you are interested in. You can highlight the schedule for an entire team, highlight Monday night games, Thursday night games, international games, and Christmas Day games. Below, I’ve flagged games involving Buffalo, New England, and Miami. I’ve also highlighted the full schedule for Green Bay, and have checked off the option for any Monday night games.
This results in various cells being highlighted on the grid:
The red highlighted cells are for any games involving the teams on the watchlist. These cells will only highlight if two of the teams from the watchlist are playing. In this example, any games involving a combination of Buffalo, New England, and Miami will be highlighted. It won’t simply highlight any games involving them.
The dark blue highlighted cells are for Monday night games. And the cells are green when an entire team is selected. Yellow highlighting will apply for Thursday night games, while cells will highlight in purple if you want to see international games. Christmas Day games will highlight in green with a red font color.
Standings will update as you enter results
As you update the scores on the Master.Schedule tab, the Standings tab will also update, showing you the ranking of each division.
If at the end of the season, the standings are very tight and tiebreakers need to be applied, you may need to use the Override tab to manually put the correct standings. This is only if the positioning is incorrect on the Standings tab. While some tiebreakers are factored in, it won’t account for every possible scenario.
By entering values 1 through 4 on the Ranking Override column, you will assign specifically where those teams should rank. They are grouped by division. As the column name suggests, it will override the rankings here. To ensure no issues, if you use this column, enter all the rankings for any division where the standings are not correct.
Making predictions on the NFL template
On the Weekly.Predictions tab, you’ll see a list of the week’s games, similar to the Weekly.Schedule tab. But in addition to the schedule, you’ll also have an area to determine scoring rules for your predictions. You can specify the number of points awarded for a correct result, correct # of total points, if the exact score is correct, if the person beat the spread, if they got the over/under correct, and if there was a push on either the spread or the over/under.
If you are making predictions based on the spread and the over/under, you will need to manually update those columns .
On the other side of the sheet, there is an area for players to make their predictions for each game.
You can change the names from Player 1, Player 2, etc. to the actual names of the people making the predictions. The sheet supports up to 25 players. If you don’t need that many, simply delete the values in those cells for the names.
The points will total once both predictions are made and there are actuals that have been entered on the Master.Schedule tab (those values will populate on the Weekly.Prediction tab).
Lastly, on the Leaderboard tab, you can copy the results for the current week into the actuals section. The current week’s scores will populate below the row highlighted in yellow, which indicates that there are formulas below:
Copy these values above to the corresponding week, in the Actuals section:
As data is entered and updated, the cumulative results and chart at the top will update. However, to update the chart, you will need to refresh the data. This can be done by going into the Data tab and clicking Refresh Data.
Try out the NFL prediction and schedule template today!
If you have any feedback or suggestions on the template, I’m always happy to hear them as I’m always lookin for ways to make the template as best as it can be!
If you liked this NFL Schedule and Prediction Template, please give this site a like on Facebook and also be sure to check out some of the many templates that we have available for download. You can also follow me on Twitter and YouTube. Also, please consider buying me a coffee if you find my website helpful and would like to support it.
Are you looking for a free English Premier League Prediction Template to track matches, make weekly predictions, and see how your forecasts stack up against your friends’? This all-in-one spreadsheet is perfect for EPL fans who want an easy way to manage the 2025–26 season.
What’s Included in the EPL Template?
This English Premier League prediction spreadsheet has five tabs:
Master.Schedule
Team.Schedule
Weekly.Schedule
Weekly.Predictions
Leaderboard
Master.Schedule: The Core of the EPL Template
This is the main tab where you manage all fixtures and results. Update scores in columns J and L, and adjust for your time zone using the fields in column A if you want the time and date to update in columnG for the schedule.
Want to follow your favorite clubs? Use the watchlist starting at cell A12 to highlight one or more teams. This affects other tabs like Weekly.Schedule, helping you quickly spot the matches that matter most to you.
As you update the results, the standings update automatically in columns AF:AI. If necessary, you can manually set tiebreaker positions in column AK, should the tiebreakers get to that point.
Team.Schedule: View Fixtures for a Single Team
In this tab, pick your team from the dropdown in cell A3, and their schedule auto-populates in columns B:N. It’s a clean, filtered view for tracking just one EPL team. The team is highlighted in grey, and no manual editing is required—this tab pulls directly from the master schedule tab.
Weekly.Schedule: Focus on One Week at a Time
In this tab, enter a week number in cell A3, and the tab displays all fixtures for that week. Matches involving any teams in your watchlist are highlighted for quick reference. Again, no need to manually enter anything—scores flow from the master tab.
Weekly.Predictions: Compete with Friends
Want to run a weekly EPL prediction game? This tab lets up to 10 players make predictions and earn points. And with this, you can specify the week you want to make predictions for — there’s no worry if you start late or haven’t been making predictions since the start.
Enter the week number in cell A3.
Customize the scoring system (e.g., 1 point for the correct result, 2 for correct goals, 3 for exact score).
Add player names in row 2 and enter predictions starting in column P. There is room for 25 players. If you don’t need them, just delete the names, and they won’t populate on the leaderboard tab.
Scores will auto-update based on the scores from Master.Schedule – do not make changes and enter actual results on this sheet.
Leaderboard: Track Your Prediction Results
The current week’s results will populate on the leaderboard, in row 72:
When the week is complete, copy the values to the table above, which is where you can update the points per week, in the actuals section.
In the above example, I’ve filled in values 1 through 25 for each of the players. You will override this with your own prediction results for week 1. And then as the following week completes, copy the scores (from row 72) to the correct section on the actuals.
The data will then populate above, giving you a cumulative score for each player, along with a chart, showing the results visually.
On the Google Sheets version, the chart will automatically update. However, on Excel, since a pivot table is used to show only the active players, you will need to Refresh the data (from the Data tab). Otherwise, the chart will not update. There is a reminder on the Excel workbook to do this refresh.
Updated scores will now update via Power Query and Google Sheets
8/20 Update: With the latest file, you no longer have to manually input the scores anymore. I have a file that will update with the latest scores, and that will flow through to the Google Sheets and Excel files. For Excel, you will need to refresh the query to get the latest data, it will not pull in automatically. To do this, go to the Data tab and click on Refresh Data. By doing this, the file will download the scores.
Please note the scores are not live or up to the minute. I’m using AI to periodically update the data, and while I will attempt to update it by at least the end of each day that there is a game, I cannot guarantee that will always be the case. If you prefer not to wait, you can still update the scores and override the formulas within the file. But at the very least, you won’t have to input all the scores anymore.
Download the English Premier League Prediction Template
If you’re ready to go and want to give the template a try, you can get started right now:
When you click on the link, you’ll be prompted to make a copy of the file. This is to ensure that you have your own unique version of the file to work with.
This Premier League Prediction Template for Excel and Google Sheets is completely free to use and customize.
If you have any comments, questions, or suggestions about the template, please contact me!
If you liked this English Premier League Prediction Template for Excel and Google Sheets, please give this site a like on Facebook and also be sure to check out some of the many other templates that we have available for download. You can also follow me on Twitter and YouTube. Also, please consider buying me a coffee if you find my website helpful and would like to support it.
Want to track events, bills, and tasks easily? Rather than using different apps, you can do all of that right within Google Sheets. Whether you’re using your home computer or using your phone, it’s easy to access Google Sheets — all you need is a link to the sheet that you’re using. In this article, I’m going to share with you my free Dynamic Calendar Template which will make it easy to keep track of all your important dates and deadlines. Below, I’ll leave a link to the file, where you can create a copy of it and use it for your own personal needs, and it’s completely free.
How the Dynamic Calendar Template works
There is just one main tab on the Dynamic Calendar Template, where you can enter your events and see your calendar at a glance. In its most basic form, it gives you an easy way to view the current month, and easily change from one period to another.
By default, it will automatically set to the current month. If, however, you prefer to change the period, you can override the formula in cell C3 by just entering the month and year. For example, typing in ‘April 2025’ will update the calendar to that month and year. Simply enter it in that format and it will update accordingly.
You’ll notice that the current day is highlighted in yellow. And at the top, there is a drop-down option next to the date. This allows you to use to swap between different calendars. If you want to see all due dates and events, simply leaving the ‘All’ option selected. But each day is limited to five events, so if you have more than that, you’ll want to consider using more than one calendar type.
Setting up different calendars
In column Q, there is a table for different calendars. In addition to All, there are Personal and Work calendars setup as well. If you select All, however, all of your items will be included on the calendar, regardless of which option you designate for your event. But if you select Personal, Work, or another calendar type, only entries for that calendar will be displayed. If you want to enter a new calendar type, simply enter a value below the latest one, the Work calendar, so that the table expands:
In the above example, I’ve added a ‘Stocks’ calendar to track events related to stocks, potentially including earnings dates and other stock-specific events.
Creating events
Once you’ve setup your calendars, you can begin entering events in columns L:O. While this is called ‘events’ it can technically include anything you want to keep track of — meetings, bills, etc.
There are just four fields to enter values for:
Date: the day the event takes place
Event Description: what the event is
Calendar: which type of calendar it falls under
Flag: if you want to flag this with a certain color (currently you can use black, blue, or red flags)
In the following example, I’ve entered three events for March 5, 2025:
While I have entered in a value for a flag, this is not necessary. With my ‘All’ calendar drop-down option selected, I see all of these events displayed for March 5:
However, if I change the calendar to show only Personal, only the Mortgage Payment event which was tagged with that calendar, will appear:
Download the free template
You can download the Dynamic Calendar Template from this link, which will prompt you to create your own copy. In order to ensure it works as designed, please avoid making changes to other cells. The only places you should make inputs are in the month and year (should you want to change the default from the current period), and the two tables — one to manage events, and the other for the different types of calendars. If have also created an Excel-based calendar, which you can check out here.
If you like this Free Google Sheets Calendar Template to Track Bills and Events, please give this site a like on Facebook and also be sure to check out some of the many templates that we have available for download. You can also follow me on Twitter and YouTube. Also, please consider buying me a coffee if you find my website helpful and would like to support it.
Excel can help you reconcile your accounts and prepaids with ease. And below, I’m going to go over an updated version of my prepaid expenses template. This new template will make it easier to add items and years, by going across rather than vertically.
There are only a few columns where you’ll need to enter any inputs in, and that’s in columns A:D. This is where you enter the type of prepaid you want to track, the starting balance, along with how many periods you want to amortize it over (duration), and the first period the amortization should begin. Do not change the values in the period cost field as they are calculated by formulas.
Below, you can also enter the actual GL balance, to help you calculate any differences between the balances and the GL. In the example above, I have a variance of 1,000.
Once you enter the inputs for the prepaids, the rest of the template will populate, with the first month representing the first period, followed by period 2, and so on. In the below screenshot I have set Jan 2025 as my first month but that can also be adjusted and it is highlighted in yellow to let you know that this is a field which you can change.
There are a total of 60 periods in the template to accommodate up to five years of data, but this can be expanded.
The template will calculate your total amortized cost for the period, as well as the year-to-date (YTD) amounts since the start of the year, and those will reset again after every 12 periods. This way, you can track both your individual monthly amortization costs as well as your running total for the year. This is why you may want to have your first period be January, even if you don’t want to start amortizing in that month — you can simply change the first period which amortization starts, to ensure the YTD values calculate properly.
How to get the template
You can download this template for free, here. The free version is locked and is limited to tracking five items. If you want more, you can get the full version from here, which is unlocked.
If you like the 2025 Prepaid Expenses Template, please give this site a like on Facebook and also be sure to check out some of the many templates that we have available for download. You can also follow me on Twitter and YouTube. Also, please consider buying me a coffee if you find my website helpful and would like to support it.
It’s a new year and with the help of a good calendar, you can ensure you stay on top of not only your deadlines and tasks but goals as well. I have a free template which you can download and use for such purposes. With just a few clicks, you can populate a new month, select a custom image, and also have key dates and deadlines appear. And all this is available in a format which is easy to print out.
How the calendar template works
The calendar will populate the days of the month you specify, including the days before and after the end (these dates will be highlighted in grey). You can change the picture for the month and adjust its size depending on how big or small you want it to be. To do this, you can just right-click on the picture and select Change Picture. I’ve also left an area off to the left as blank, giving you room to make any notes.
If you want to change the month, year, or the day that the week starts (either Monday or Sunday), go to the Inputs tab where you can modify those settings.
This is also the tab where you can enter any tasks or deadlines you want to track. They don’t have to be for the current month. Suppose, for example, you have a property tax bill that’s due in July. You can put that task there along with any others you want to track:
These dates will show on the calendar depending on the month selected. If January 2025 is selected, then only dates related to that month will appear.
The advantage with this template is that you can enter all your tasks and deadlines for the year and they will show only for the month you specify. This can make it easier to stay on top of tasks without having to remember to enter them all in for that specific month; you can enter them ahead of time and setup recurring ones as well. There is room to accommodate up to five tasks/deadlines for each day.
If you like this Free Calendar and Task Manager Template, please give this site a like on Facebook and also be sure to check out some of the many templates that we have available for download. You can also follow me on Twitter and YouTube. Also, please consider buying me a coffee if you find my website helpful and would like to support it.
Do you want to track deadlines and have an easy place to manage all your upcoming tasks and bills? In this post, I’m going to share with you my Dynamic Calendar Template. This template will allow you to input dates and create conditional formatting rules so that it’s easy to see important items on your calendar. You can also see up to five items per day and switching between different months and years, so you’ll only see items for that specific month.
Everything is conveniently available in a single tab and there are no macros in this file. The calendar is on the left-hand side of the page while the events and important dates you input are on the right.
Today’s day will automatically highlight in yellow. To add events, all you need to do is input a date, a description for the event, and you can also specify a flag (conditional formatting rule) that you want to apply to that item. In the example below, I’ve setup events for Nov. 28 and Nov. 29.
Since I’ve set flags for the specific events, they are highlighted accordingly in my calendar. You don’t need to specify a color, but it is not necessary to do so.
You can also change the dates for the calendar by adjusting the month and year options in-between the calendar and the events table. If the events don’t relate to a specific month, they won’t appear on your calendar. This way, you can add many events far into the future and they won’t appear on your calendar until you are viewing that specific month and year.
You can download the free template available here.
Use the premium version for multiple calendars and recurring events
There is also a premium version available for this template which will allow you to use macros to generate recurring events. And you can also add multiple calendars. If you want to balance personal, work, family, and other types of calendars, you’ll be able to do that with this template. On the main calendar tab, there is an additional drop-down option where you can specify which calendar you want to use, in addition to setting the month and year.
On this template, there is a separate sheet for inputs, where you can add to the list of calendars and when entering events, you can include which calendar you want to use. To setup recurring events, I can create the events that I want to setup and specify how many events I want to generate in advance. And upon clicking the macro button, it will add them to the events table.
After clicking Generate Recurring Events, the events table is now populated with events for the next 12 occurrences. Since, in this case, they occur every 12 months, it will add the annual occurrence for the next 12 years.
Once the events are created, the value for the # of events to generate resets back to 0. The macro will only create instances when this value is filled in, the avoid creating extra events.
You can, however, remove any events by just right-clicking on the events listed and selecting Delete Table Rows.
Now, when going back to the calendar and adjusting the date to July 2025, the first even will appear.
If you are interested in purchasing the premium version, please visit the product page here.
If you like this Dynamic Calendar Template, please give this site a like on Facebook and also be sure to check out some of the many templates that we have available for download. You can also follow me on Twitter and YouTube. Also, please consider buying me a coffee if you find my website helpful and would like to support it.
The Paris Olympics are taking place next month, and one of the more popular tournaments is likely to be the men’s football competition, which will include 2022 World Cup finalists France and Argentina. I have created a template in Google Sheets which will help track the tournament and allow you to make predictions with others.
Tracking matches in the template
On the main page of the template, there is a tab for Actuals where you can enter the actual results as they occur. And based on those results, the tables will automatically populate, to determine which teams will play one another in the knockout stages.
You can also highlight countries you want to track by specify the name of country under the watchlist section below. There is also a space to adjust the time based on your time zone. In the example below, the match times are adjusted based on GMT-4. I have also chosen to highlight all the matches where either France or Argentina play.
Making predictions in the template
In addition to tracking the matches and results, you can also make predictions with your friends. There are five predictions tabs in the file. The tabs are the same as the actual tab. The one difference is that there is column for prediction points earned. The prediction results will compare to the actuals to determine if a result was correct and if so, the number of points that someone should have earned from that prediction.
You can adjust the points someone will earn by making changes to the scoring rules tab. Here are the default rules that are in the sheet:
Points can be earned for determining the correct number of goals, the right result, score, and even if the teams were correctly predicted to be in the correct elimination stage.
To track how all the players are doing, update the scoring results tab with the name of the players — this should match the individual tabs. If you rename Player1, Player2, etc, then be sure to adjust the names on the scoring results tab. If you need more players, you can copy one of the existing player tabs.
Try the template!
This template is available for free and you can access it by clicking on this link. It will create a copy of the file which you can then use.
If you like this free template for the Men’s Olympic Football Tournament for Paris 2024, please give this site a like on Facebook and also be sure to check out some of the many templates that we have available for download. You can also follow me on Twitter and YouTube. Also, please consider buying me a coffee if you find my website helpful and would like to support it.
The UEFA Euro 2024 tournament is beginning in June 2024. And whether you want to track the games, make predictions, or just print out a schedule that highlights the games you want to track, this template has you covered. Below, I’ll go over how the template works, how to use it, and where you can download it.
Tracking the games in your time zone
The template has a schedule of all the games in the tournament. And you can adjust the schedule by entering your time zone adjustment (e.g. for -4 GMT you would enter -4 whereas if you are +10 then you would enter just a positive 10). Based on that, the column for your local time will update to show what time the game is in your part of the world.
You can also track the teams you want to keep an eye on by entering them in the Watchlist area. In the following example, I’ve flagged matches involving England and Spain:
Entering scores and updating the results
You can also enter the scores as the games, and that will update the standings and determine the round of 16 and other elimination games. In the elimination games, if the score is tied, you can enter in extra time scores and penalties.
While there are tiebreakers setup in the template which should handle the vast majority of scenarios, there are also sections where you can override the standings for both the individual tables and for the third-place rankings. If you’re applying overrides, you’ll need to fill in the entire group standings, such as below:
In the override column, I’ve specified the position for each team, and the table for the group also reflects that.
Printing out a schedule tracking multiple teams
On the Printout tab, there is a schedule that you can print out on a single page. This too, will automatically adjust based on the GMT value you entered on the Actuals tab. You can specify whether you want the time to show in AM/PM format or as a 24-hour clock. And here too, you can have a watchlist to help highlight teams you want to track.
Entering and tracking predictions
This template has, by default, five tabs created for predictions: Player1, Player2, Player3, Player4, and Player5. In each of these tabs, you can enter your predictions by entering your expected results. There is an extra column for Prediction Points Earned which will tell you how many points you earned for that particular prediction.
This is based on the scoring rules you specify on the Scoring.rules tab.
To compare how you have performed against other people, go to the Scoring.Results tab. Here, you’ll just need to update the list of players. Instead of Player1, Player2, etc., you can change this to represent actual names. You can also add more players/predictions by simply creating a copy of the player tabs.
Note: you will see a #REF! error on the results tab if you have changed the tab name but you have not changed the list of player names on the Scoring.Results tab.
Download the template
The template is available to download here. There is also a Google Sheets version which works the same way, which is available here.
If you have any feedback, suggestions, or come across any issues, please let me know.
If you like this Free UEFA Euro 2024 Prediction Template and Schedule, please give this site a like on Facebook and also be sure to check out some of the many templates that we have available for download. You can also follow me on Twitter and YouTube. Also, please consider buying me a coffee if you find my website helpful and would like to support it.
Do you buy stocks? Help track your transactions and your returns with this stock trading template. This is an update over the previous stock trading template, offering more reports and analysis, and the ability to more easily track your portfolio’s performance. In this post, I’ll go over how the template works, and how to use it.
Using the stock trading template for the first time
When you first use the 2024 stock trading template, there are a few items you may wish to modify on the Settings tab. These are the end date (by default set to today) and the short-term trading days cutoff. The end date is used because the reporting tab looks at the trailing 12 months. So if you want a cutoff as of Dec. 31, 2023 and see the full year, you can modify the cutoff there. But if you want to look at your returns up until today, you can leave that as is, up to today’s date.
The short-term trading days cutoff is used for a report which pulls your gains and losses over this number of days. If you’re a very active trader, you my want to lessen this interval to 30 days or less. If, however, you don’t trade that often, you may prefer a longer cutoff. The default is set to 60.
Enter transactions in the file
To make the data-entry process simple, there is a userform which will allow you to enter your buy and sell transactions. You can also enter starting balances and dividend payments. You can access the form from the Trading Journal section on the Home tab, right within the Excel ribbon.
By clicking the Enter Transaction button, you will see the following form pop up:
To start, you can use the Date Picker button to select the transaction date. With the date picker, you can use the button on the left and right side to move one month at a time. You can also select the month from the drop-down list. You can change the year by just typing in the year of the transaction. Once you have the right date and month, use the tab key so that the calendar updates. Then, click on the date the transaction relates to.
Next, select the action type. This will determine which fields you need to enter. There are multiple options to choose from.
If you are buying a new stock you don’t already own, select Open New Position.
If you already own a stock and are adding more shares, select Add to Existing Position.
If you are selling shares of a stock you own, select Sell Shares.
If you are adding cash to your portfolio, select Enter Contribution.
If you are withdrawing cash from your portfolio, select Enter Withdrawal.
If you are recording dividend payments, please select Enter Dividends.
If you are already own stocks and need to enter in your initial positions, select Starting Balance. For starting cash positions, use the Enter Contribution option.
You will then see a different form based on your selection, showing you which fields you need to enter.
Using different investing strategies
By default, there are three investing strategies you can select from when buying a stock: Buy and Hold, Contrarian, and Speculative. This can be helpful if you want to track how your different strategies work. If you don’t use different strategies, you can just leave everything as Buy and Hold. If, however, you want to add or modify strategies, click on the Update Strategies button when entering a new position:
That will then populate a new userform where you can manage the different strategies.
How the template tracks transactions
When you enter a transaction, it goes into two places. One is the Activity tab, and this acts as a log for everything you’ve entered. There is also the Transactions tab, which is designed for traders to track their opened and closed positions.
The data also flows through to the Summary tab, where you will be able to see your running portfolio balance, track gains and losses, and also see reports highlighting your overall trading performance. To make sure that all the charts update correctly, click on the Refresh button from the Trading Journal section on the Home tab.
Download the template
Want to try out the template? You can download the trial version here. It is limited to 25 transactions. If you like it, please consider purchasing the full version.
If you run into any issues with the template or have feedback or suggestions for improvements, please feel free to contact me. Please include the name of the template when drafting your message.
If you like the 2024 Stock Trading Template, please give this site a like on Facebook and also be sure to check out some of the many templates that we have available for download. You can also follow us on Twitter and YouTube.
