Jump to content

Welcome to the new Traders Laboratory! Please bear with us as we finish the migration over the next few days. If you find any issues, want to leave feedback, get in touch with us, or offer suggestions please post to the Support forum here.

  • Welcome Guests

    Welcome. You are currently viewing the forum as a guest which does not give you access to all the great features at Traders Laboratory such as interacting with members, access to all forums, downloading attachments, and eligibility to win free giveaways. Registration is fast, simple and absolutely free. Create a FREE Traders Laboratory account here.

Recommended Posts

I have an Excel book which I've created to record each trade (Date/Time/Market/Setup/LongShort/EntryPrice/Stop/Stake/ProfitLoss) then columns for Trade Management (moves to stops limits, etc), comments and various other stats - for every trade. This means I can also keep track of 'paper' trades and cash ones, whilst keeping results separate.

 

I then have a further sheet to summarize each traded day and then a 3rd one to summarise weeks. Keeping paper / cash separate also helps to establish how well I'm 'converting' setups into real trades when everything gets summarized.

 

I have the whole thing automated to do the summaries etc once I put in the basics of each trade and I find it very helpful to keep track of everything. This may not be what you are after (you may want more emphasis on written info and descriptions of trades and days rather than strict record keeping) but thinking through and drafting something like the above could be a good starting point for you...

Share this post


Link to post
Share on other sites
I have an Excel book which I've created to record each trade (Date/Time/Market/Setup/LongShort/EntryPrice/Stop/Stake/ProfitLoss) then columns for Trade Management (moves to stops limits, etc), comments and various other stats - for every trade. This means I can also keep track of 'paper' trades and cash ones, whilst keeping results separate.

 

I then have a further sheet to summarize each traded day and then a 3rd one to summarise weeks. Keeping paper / cash separate also helps to establish how well I'm 'converting' setups into real trades when everything gets summarized.

 

I have the whole thing automated to do the summaries etc once I put in the basics of each trade and I find it very helpful to keep track of everything. This may not be what you are after (you may want more emphasis on written info and descriptions of trades and days rather than strict record keeping) but thinking through and drafting something like the above could be a good starting point for you...

 

Would you be willing to share this? I have something more basic, but is not clever enough with Excel to automate everything and is doing everything by hand, which is kind of a pain to do.

Share this post


Link to post
Share on other sites

Template attached.

 

Hope it makes sense to everyone with a bit of playing around - just make sure to continue the formulas as you fill it in and everything should run smoothly. I just put 2 fictional trades on the tradesheet (one 'paper' one 'live') to give you an idea of how I personally fill it out.

 

Also, I have a few beta things going on on my own version but if anyone else has ideas on stats / info they'd like to add or see calculated then lets hear them! I'm no Excel expert but always happy to try and create solutions...

Bear Mtn Trade sheet.xls

Share this post


Link to post
Share on other sites

Thanks Bear,

 

I Think this will do fine. I will plug in some data that I have been keeping, over the weekend. If I need help adding any formulas I will post them.

I know a lot of software has back testing ext. but I would have thought more people would have responded or wanted a good excel template for their live or demo accounts. I guess its that 90% thing. Oh I mean 10% do 90% of the work thing. :crap:

Share this post


Link to post
Share on other sites

Thanks Bear,

 

I like to keep things simple. This is exactly what some of us might need. Even if one of these start out that way, people tend to add their own bells and whistles. For me, this will be a great starting point. Thanks again.

Edited by Bohunck
typo

Share this post


Link to post
Share on other sites

I have a good spreadsheet that I've used and improved for a while that allows you to keep track of scaleouts, add-ins, etc., and calculates pts profit, $ profit, and so on based on entry/exit prices. I've given it to a few people to play around with and test, and will post it when I'm certain enough that it's bug free.

Share this post


Link to post
Share on other sites
scaleouts, add-ins, etc., and calculates pts profit, $ profit, and so on based on entry/exit prices.

 

Really interested to see this Atto as finding a way to accurately represent multi-entry/exit trades has been one thing I've struggled with. I now do this fairly manually which I think gives me an accurate way to benchmark these against simpler trades.. but like I say, look forward to seeing your setup or hearing how you handle these?

Share this post


Link to post
Share on other sites

Yeah, that was the hardest logically, but I really wanted it to work that way. Still trading now, and I need to fix a couple things, then I'll post it.

 

Here's how the trade journal section looks (and you might get an idea how I managed scaleouts and adds):

 

attachment.php?attachmentid=11646&stc=1&d=1245775961

 

The data entered is Date/Time, Instrument (entered or selected from a menu that's easy to set up), size, and price. The rest is calculated: position (showing the total position on that instrument) and profit (in pts and $, taking into account the average entry price). Cumulative profit, Drawdown, and some other stats are also kept track of.

tj.PNG.fdc316c510e59669f6611b5a85fc8d83.PNG

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Topics

  • Posts

    • RKLB Rocket Lab stock watch, at 18.86 support, high trade quality, getting ready to launch at https://stockconsultant.com/?RKLB
    • PRCH Porch Group stock, watch for a bull flag breakout above 7.19 at https://stockconsultant.com/?PRCH
    • PLTR Palantir Technologies stock, nice close and local breakout at https://stockconsultant.com/?PLTR
    • COIN Coinbase stock watch, pullback to 184.7 support area with bullish indicators at https://stockconsultant.com/?COIN
    • Date: 24th March 2025. Market Uncertainty Intensifies Amid Tariff Concerns   Uncertainty has been the driving force in financial markets this year, with recent weeks seeing increased volatility due to ongoing tariff concerns. The global economy is grappling with the effects of the Trump Administration's levies, exacerbating fears over inflation and economic growth. Escalating trade tensions and geopolitical risks continue to weigh heavily on investor sentiment. Central banks, while adopting a wait-and-see stance, lean towards a dovish bias (excluding the Bank of Japan) amid rising threats of economic slowdowns. More market turbulence is expected in the short term as the world anticipates the outcome of Trump's April 2 reciprocal tariff decision. North America: Key Market Events and Economic Indicators A packed economic calendar awaits the US this week, featuring key data releases, Federal Reserve commentary, and Treasury supply ahead of quarter-end. Markets remain fixated on the much-anticipated April 2 "tax date" for the imposition of reciprocal tariffs. However, in an unexpected turn, President Trump suggested "flexibility" on tariffs, adding another layer of uncertainty to market expectations. Key economic releases include: February PCE Price Index (Friday) – The Fed’s preferred inflation gauge, which will be closely monitored for signs of tariff impacts. January's data showed a 0.3% increase in both headline and core prices, with annual rates at 2.5% and 2.6%, respectively. February’s report is expected to show a similar trend. March Consumer Confidence (Tuesday) – Expected to decline by 4.3 points to 94.0, marking the lowest level in over four years. Durable Goods Orders (Wednesday) – A crucial indicator of business investment and economic activity. Flash March PMIs and Housing Data – Additional data points that could influence market sentiment. Australia’s Inflation Data (Wednesday) Federal Reserve officials are set to speak throughout the week, though clarity on future policy moves remains unlikely. Key remarks from voters such as Kugler, Barr, and Musalem will be closely analyzed. Treasury Auctions and Market Yields The Treasury market is preparing for $183 billion in shorter-dated note auctions: $69 billion in 2-year notes (Tuesday) $70 billion in 5-year notes (Wednesday) $44 billion in 7-year notes (Thursday) The 10-year U.S. Treasury yield edged higher, while the dollar remained steady. Meanwhile, the Turkish lira dropped as market volatility persisted due to geopolitical uncertainties. Stock Market Update: US and European Futures Rise US and European stock futures climbed amid signs that the next round of President Trump’s tariffs may be more measured than initially feared. S&P 500 and Euro Stoxx 50 futures advanced, while Asian equities posted mixed performance. Key Developments Impacting Stocks Targeted U.S. Tariffs: Reports suggest that the next round of US tariffs will be more focused rather than a broad-based global effort. China and Australia have warned of potential economic shocks from US trade policies. Investor Sentiment: "The news of more targeted tariffs has been taken positively during early Asian trading hours, but markets remain on edge," said Khoon Goh, Head of Asia Research at ANZ Group Holdings Ltd. Geopolitical Concerns: Turkish assets face increased volatility following the arrest of a key opposition politician, prompting the country’s central bank to hold a "technical meeting" with commercial lenders in preparation for further market swings. Corporate and Sector-Specific News Ant Group’s AI Strategy: The Jack Ma-backed Ant Group Co. is leveraging Chinese-made semiconductors to develop AI models that cut costs by 20%, boosting optimism in Chinese tech stocks. DeepSeek’s AI Influence: The release of a lower-cost large language model by DeepSeek has fueled a 26% rally in Chinese technology shares this year, with analysts predicting further valuation expansion. Commodity Markets: Oil prices remained stable amid uncertainty over new US tariffs and an expected increase in OPEC+ supply. Gold hovered around $3,027 per ounce, near its all-time high reached last Thursday. Conclusion With market volatility heightened by trade uncertainties and global economic concerns, investors will closely track developments in tariff policy, economic data, and central bank commentary for signs of future trends. As April 2 approaches, markets brace for potential disruptions and opportunities in response to evolving US trade strategies. Always trade with strict risk management. Your capital is the single most important aspect of your trading business. Please note that times displayed based on local time zone and are from time of writing this report. Click HERE to access the full HFM Economic calendar. Want to learn to trade and analyse the markets? Join our webinars and get analysis and trading ideas combined with better understanding of how markets work. Click HERE to register for FREE! Click HERE to READ more Market news. Andria Pichidi HFMarkets Disclaimer: This material is provided as a general marketing communication for information purposes only and does not constitute an independent investment research. Nothing in this communication contains, or should be considered as containing, an investment advice or an investment recommendation or a solicitation for the purpose of buying or selling of any financial instrument. All information provided is gathered from reputable sources and any information containing an indication of past performance is not a guarantee or reliable indicator of future performance. Users acknowledge that any investment in Leveraged Products is characterized by a certain degree of uncertainty and that any investment of this nature involves a high level of risk for which the users are solely responsible and liable. We assume no liability for any loss arising from any investment made based on the information provided in this communication. This communication must not be reproduced or further distributed without our prior written permission.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.