MikeL 10:19 am on Saturday, December 17, 2022

Question about keeping track of trades

Over the years, I have noticed that keeping track of trades is taking 2 to 3 times longer that the actual trading activities.

I use Excel spreadsheet and entering open/close trades is not a big deal. However, when I roll positions, sometimes for years, it is a tedious task.

Has anyone found a better way of recording trades (than Excel), including multiple rolls?

fuzzballl 12:50 pm on Saturday, December 17, 2022

Mine is even more archaic than excel. It’s sort of a homemade system that’s developed over the years. Basically tracking everything manually. I’ll catch up every couple days or sit down on the weekend and do the whole week. Maybe it’s my inner nerd coming out but I actually enjoy it.

I enter the original position and then keep a running total as I do rolls with the current position and the updated premium received. This is after commisssions and rounded to the nearest nickel. If I get assigned stock I like to know the actual price paid for the shares and the assignment price with put premium included also.

Nothing fancy but gets the job done and doesn’t take too long to update once you get into the swing of it.
- MikeL 7:33 am on Sunday, December 18, 2022
  
  I do accurate calculations in Excel, as I just must know my cost for shares and accumulated premium. It works fine when you have a couple of positions, but with a number of positions in multiple accounts, time use is just “foolish”. Kind of earning less than minimum wage for doing data entry 🙂 🙂
  
  If only I could use that time on planing new trades…
  I guess, it is just wishful thinking. 🙂
  - fuzzballl 8:09 am on Sunday, December 18, 2022
    
    Here’s what a couple friends of mine use. I don’t know much about it but they seem to like it.
    
    https://wingmantracker.com/
fuzzballl 12:51 pm on Saturday, December 17, 2022

I tried responding but waiting for approval again.
- MikeL 7:33 am on Sunday, December 18, 2022
  
  Not sure why approval is required. Must be a WordPress glitch somewhere.
  - fuzzballl 8:09 am on Sunday, December 18, 2022
    
    Yep. Sometimes when I insert an image I get put in timeout. Lol

Leave a Reply Cancel reply

The Wait is Over

We have finally made it. Our top 6 albums of all time. The final episode of The Pick 100 is available now. https://thepickcast.com/

The top is intractable. The end is ineluctable. The finish is forthcoming. We resume the revealing of our revered records of rock with picks 13 through 7; an all-new episode of The Pick. Watch the promo above, then go to our Pick 100 page to link to the episode. It’s also your LAST CHANCE to […]

Only 21 left before #1

As we push our way to #1, we tick off picks from Zeppelin, Liz Phair, Rage Against The Machine, The Police, and Marvin Gaye. We have our first guest on a Pick 100 episode, Leif Sandaas, college friend and man responsible for our love for R.E.M. And a “radio play” to tell the story of […]

#30-22 are here… and you can dance to them

Our Favorite 100 Albums countdown continues, as we have reached numbers 30 through 22. Beastie or Blondie; Mac or Boy; Uh-Huh or Hum; Steely or Straits; Prince or PJ; Ten or 1999; Earth, Wind, Fire, Hell, or Purple Rain… which will rank higher? Led Zeppelin IV is Jeff’s pick at #23, and it features “Stairway […]

The Best Music of 2021

Anticipated by no one and ignored by most, here are my picks for best albums and songs of 2021. You can click on each album to link to Spotify, or the underlined album title for Apple Music. My favorite songs are compiled on playlists on both Spotify and Apple. Click here for song playlist on […]