Dark Theme
Light Theme
Trading Articles
Article Categories
Article Tools
Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to
register in order to view the content of the threads and start contributing to our community.
It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
Updated February 19, 2021
Top Posters
looks_one
elwoodpdowd
with 8 posts (3 thanks)
looks_two
Smith33
with 3 posts (0 thanks)
looks_3
RedK
with 3 posts (1 thanks)
looks_4
No2Fool
with 3 posts (1 thanks)
Best Posters
looks_one
sam028
with 3.5 thanks per post
looks_two
dave01
with 3.5 thanks per post
looks_3
Rambo
with 3 thanks per post
looks_4
Martzee
with 1.7 thanks per post
trending_up
40,789 views
thumb_up
36 thanks given
group
33 followers
forum
45 posts
attach_file
10 attachments
April 20th, 2016, 05:26 PM
HAWAII
Posts: 3 since Apr 2016
Thanks Given: 2
Thanks Received: 0
dave01
I use two spreadsheets, one that is updated "realtime" by
TOS and is my monitoring spreadsheet, and another that is my historical
P&L tracking spreadsheet. I've made some very elaborate spreadsheets in the past, but I found that building and using them detracted from my trading.
As of just a month ago, I've greatly simplified my spreadsheets. My new spreadsheets are simple, but are a bit more hands on when adding new trades and making adjustments. It takes some experimentation to find what works best for you. For what it's worth, I've attached a
screenshot of my monitoring spreadsheet so that you can get an idea of the column layout.
All of the TOS updated cells have formulas similar to: =RTD("tos.rtd",,"MARK",B3)
Where B3 is a reference to the underlying that I want the mark/mid price.
Hey Bro,
Can you send me a copy of the spreadsheets. w.edmonds@hotmail com
thanks
Can you help answer these questions from other members on NexusFi?
Best Threads (Most Thanked) in the last 7 days on NexusFi
April 20th, 2016, 05:28 PM
HAWAII
Posts: 3 since Apr 2016
Thanks Given: 2
Thanks Received: 0
Martzee
I use Google Spreadsheet for this purpose because this allows me to have the spreadsheet accessible from any computer anywhere and anytime.
I am not yet allowed to post links so PM me and I can share it with you. Bellow is a picture of what I use. I can also help you with what you need (but only in Google spreadsheet as my Excel knowledge of financial and date feed functions is limited).
Hey Bro,
can you send me a copy of the spreadsheet w.edmonds@hotmail com
thanks
April 20th, 2016, 06:21 PM
Vail, CO USA
Posts: 12 since Jan 2015
Thanks Given: 6
Thanks Received: 9
Smith33
Hey Bro,
Can you send me a copy of your spreadsheet. w.edmonds@hotmail
thanks
I no longer use that spreadsheet. I have a different one, basically a single spreadsheet for a single stock ans a summary. If you want you can join our trading group on Facebook and download it there: https://www.facebook.com/groups/putdividends/
April 20th, 2016, 06:23 PM
Vail, CO USA
Posts: 12 since Jan 2015
Thanks Given: 6
Thanks Received: 9
Smith33
Hey Bro,
can you send me a copy of the spreadsheet w.edmonds@hotmail com
thanks
Here is the new spreadsheet:
September 4th, 2016, 10:25 PM
Dallas, Texas
Posts: 1 since Aug 2016
Thanks Given: 0
Thanks Received: 0
dave01
Here's a
screenshot of my updated monitor spreadsheet. This should give you some ideas for creating your own spreadsheet.
The cells in orange contain user entered values, while other cells contain either formulas or
TOS RTD links. Columns L, N, O, P, and Q contain straight calls to TOS RTD. The remaining (non-orange) cells contain formulas using the data from the orange user entered data cells and/or the TOS RTD cells.
Hi, did anyone happen to get a link or an attachment for this spreadsheet? I would love to try to fit it for my needs. I appreciate it!
September 5th, 2016, 01:57 PM
little rock arkansas usa
Posts: 3 since Sep 2016
Thanks Given: 0
Thanks Received: 0
bobbymays
Hi, did anyone happen to get a link or an attachment for this spreadsheet? I would love to try to fit it for my needs. I appreciate it!
would like to check this monitor spreadsheet out as well
November 19th, 2016, 12:22 PM
Kirkland WA
Posts: 1 since Jan 2016
Thanks Given: 0
Thanks Received: 0
Is Dave01 still active in futures.io? Does anyone know how to reach him, or where a copy of his trade log spreadsheet can be downloaded?
March 9th, 2017, 08:46 AM
Detroit, MI/USA
Experience: Beginner
Platform: TOS
Broker: TOS, Tastywork
Trading: Option n futures
Posts: 4 since Mar 2017
Thanks Given: 0
Thanks Received: 0
elwoodpdowd
Good Morning Dave,
Happy 4th of July and hope you have many more. The spreadsheet is perfect and I can't thank you enough for the effort.
Have a great day!
Elwood
can you send me PLEASE spreadsheet to bfumakiya at hot mail
July 21st, 2017, 10:23 PM
Buenos Aires
Experience: Advanced
Platform: Ninja trader & Oec
Broker: Daniels Trading / Open e Cry
Trading: futures
Posts: 4 since Feb 2010
Thanks Given: 4
Thanks Received: 7
I never find a spreadsheet how I need, so I had to do myself using a previous model (B&S approach).
There are some print screens, if somebody want it, just write me! Some pages are working 100% but others 80% and others 50%, I have to finish it!
cheers!
July 21st, 2017, 11:11 PM
Los Angeles, CA
Posts: 64 since May 2017
Thanks Given: 49
Thanks Received: 136
Rambo
I never find a spreadsheet how I need, so I had to do myself using a previous model (B&S approach).
There are some print screens, if somebody want it, just write me! Some pages are working 100% but others 80% and others 50%, I have to finish it!
cheers!
Rambo, looks pretty impressive. Would you be willing to share your spreadsheet on this thread?
Last Updated on February 19, 2021