Welcome to the Traders Laboratory Forums.
Beginners Forum Interested in trading but don't know where to start? Post any questions you may have here.

Reply
Old 09-30-2006, 03:09 AM   #1
dtx

Join Date: Aug 2006
Posts: 3
Ignore this user

Thanks: 0
Thanked 0 Times in 0 Posts

Daily Analysis Spreadsheet?

I would like some ideas making a worksheet for my daily analysis. Is anyone willing to share with me their daily worksheet or spreadsheet? I would like to have a brief idea of what I need to include to point me in the right direction.

Thanks and happy trading
dtx is offline  
Reply With Quote
Old 09-30-2006, 03:16 AM   #2

Soultrader's Avatar

Status: Super Moderator
Join Date: Aug 2006
Location: Tokyo
Posts: 3,623
Ignore this user

Thanks: 545
Thanked 1,370 Times in 491 Posts
Blog Entries: 4

Re: Daily Analysis Spreadsheet?

You really need to make your own. Your method of analysis may require different set of data. Use an excel spreadsheet to plot down highs, lows, open, close, gaps, etc...

Take note of market action or any economic numbers coming out. I'll post a picture of my spreadsheet but can't send it over. Hope this gives you an idea.


Note: I have 4 different pages on the spreadsheet. The first page is basic data, second is pivot points, third is any key price levels, and last is stats for all my setups/trades.
Attached Thumbnails
Daily Analysis Spreadsheet?-spreadsheet1.jpg   Daily Analysis Spreadsheet?-spreadsheet2.jpg  
__________________

Soultrader is offline  
Reply With Quote
Old 09-30-2006, 03:27 AM   #3

Join Date: Sep 2006
Location: Boston
Posts: 55
Ignore this user

Thanks: 4
Thanked 0 Times in 0 Posts

Re: Daily Analysis Spreadsheet?

Quote:
Originally Posted by dtx »
I would like some ideas making a worksheet for my daily analysis. Is anyone willing to share with me their daily worksheet or spreadsheet? I would like to have a brief idea of what I need to include to point me in the right direction.

Thanks and happy trading
That's like asking someone to hold your hand for you when you cross the street dtx. If you are familiar with excel, you should be able to make your own. If you are not willing to put in the time to make a simple spreadsheet, you are probably jumping into the wrong career.
carter is offline  
Reply With Quote
Old 09-30-2006, 02:30 PM   #4

Join Date: Sep 2006
Location: Dallas
Posts: 7
Ignore this user

Thanks: 0
Thanked 1 Time in 1 Post

Re: Daily Analysis Spreadsheet?

Nice spreadsheet Soul. On your weekly pivots do you use the last week (M-F) or the last 5 trading days and on your monthly pivots do you use the complete last month or the last 30 days?
Maverick is offline  
Reply With Quote
Old 09-30-2006, 02:38 PM   #5

Soultrader's Avatar

Status: Super Moderator
Join Date: Aug 2006
Location: Tokyo
Posts: 3,623
Ignore this user

Thanks: 545
Thanked 1,370 Times in 491 Posts
Blog Entries: 4

Re: Daily Analysis Spreadsheet?

Hey Maverick,

For the weekly pivots, I use the last week (M-F). For the monthly pivots, I will use the last month. Besides the daily pivots, all I really need to do is change the numbers before the opening of every Monday and at the beginning of every month.

Excel makes my life alot easier. Simply use formulas and input the high, low, and close to get the pivots.
__________________

Soultrader is offline  
Reply With Quote
Old 10-01-2006, 07:11 AM   #6

Join Date: Sep 2006
Location: eden prairie
Posts: 110
Ignore this user

Thanks: 278
Thanked 63 Times in 7 Posts

Re: Daily Analysis Spreadsheet?

Soultrader,

why do you not use tradestations floortraders daily pivot levels? are they inaccurate?
namstrader is offline  
Reply With Quote
Old 10-01-2006, 07:24 AM   #7

Soultrader's Avatar

Status: Super Moderator
Join Date: Aug 2006
Location: Tokyo
Posts: 3,623
Ignore this user

Thanks: 545
Thanked 1,370 Times in 491 Posts
Blog Entries: 4

Re: Daily Analysis Spreadsheet?

Quote:
Originally Posted by namstrader »
Soultrader,

why do you not use tradestations floortraders daily pivot levels? are they inaccurate?

I dont find them inaccurate but I have my own preference for plotting pivots.. I also like to customize the lines to dotted, solid, and different colors. I also like the option of enabling or disabling midpoints. Antonio (ant) made a custom pivot point indicator for me on TS... I will post them in the indicator forum. Im trying to design the forum in a custom format... should be done in a few hours.
__________________

Soultrader is offline  
Reply With Quote

Reply

Thread Tools
Display Modes Help Others By Rating This Thread
Help Others By Rating This Thread:


Similar Threads
Thread Thread Starter Forum Replies Last Post
Spreadsheet of Market Indices Soultrader Technical Analysis 2 06-06-2007 01:58 AM
Daily Charts Analysis Soultrader Technical Analysis 0 09-17-2006 09:06 PM
Dow mini (YM) Daily Chart Analysis Soultrader Market Analysis 0 09-11-2006 05:59 PM

All times are GMT -4. The time now is 05:02 PM.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
CS to VB integration by DeskLancer
©2006-2011 Traders Laboratory, All Rights Reserved.