Almost ready. First draft trading journal. Simplified to one line. Need help!

December 31st, 2020, 11:14 AM

Good morning everyone,

This is my first or second post and I wanted to share with you some of the issues I'm having with excel formulas creating my BASIC tracking journal for JUST stocks with a swing/day trading type of layout.

Most cells work. But I'm seeing some errors that I can't seem to figure out.

Follow along here: Mikes Trading Log .xlsx

Maybe someone could answer these questions without blinking an eye.

I have searched, experimented, and messed around myself for 2 days with no luck.

Prior to deciding to start building my trade plan and journal, I realized my excel experience was severely lacking.

Therefore I have been practicing and working on that and I also attached a very simple basic single journal entry to see why some of my cells arent working properly.

At this point, I'm even willing to pay someone a few dollars in order to get this over with.

This started as a forex spreadsheet too so under Currency pairs I really need that to be "tickers" but am getting errors when I try to do so.

I hope this is not a horrible first post I have looked and googled and tried to do this myself. I am even a web developer for a living I just don't know excel.

Also I notice some excel templates for trading journals use a ratio for the expectancy which is odd I'm used to seeing and reading it as a percentage.

Michael

December 31st, 2020, 11:25 AM

I'm also getting quite frustrated with these TRADERSYSNC like companies because they don't include the most important metrics for a day/swing trader.... Some of them but not all. I don't even see expectancy on tradersync it seems ridiculous. I could be entirely wrong but that's what it seems like.

December 31st, 2020, 11:42 AM

First I will attach the file again. Then I will explain where I am confused.

Mikes Trading Log .xlsx

Like I said I AM willing to pay for a little help here. I am not asking for anyone to use their time for free. I find all these journal templates out there but in one way or another they are lacking or created for forex and other types of trading. I just need a simple one for stocks so I can track my expectancy and other info.....

So far here are the trouble areas for me:

For example what do they mean a 0:1 ratio? It should be 2:1 no? Also they made a column for "#" and I am trying to figure out what that was for on the template by looking at the code.

Here is the code I have been working on based off the template I was customizing. It is much easier to see on the file itself but I also included some crappy thumbnails just to provide a visual.

December 31st, 2020, 12:02 PM

I found one of the solutions.... I found the answer to the ratio issue for risk. I was just entering the $ .50 value for the stop loss instead of the actual stop price which in this case was 24.50. Obviously, these stats are made up.

If apple was that cheap I would buy all of it!

Almost ready. First draft trading journal. Simplified to one line. Need help!

Discussion in Trading Journals

Almost ready. First draft trading journal. Simplified to one line. Need help!