Go Back   Traders Laboratory > General Topics > Beginners Forum

Frequent Questions

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

Reply
Bookmarks
del.icio.us StumbleUpon Google Digg Facebook Furl Reddit Netscape

 
LinkBack Thread Tools Search this Thread Display Modes Language
  #1 (permalink)  
Old 09-30-2006, 03:09 AM
dtx dtx is offline
Registered Trader

 
Join Date: Aug 2006
Posts: 3
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

Reply With Quote
  #2 (permalink)  
Old 09-30-2006, 03:16 AM
Soultrader's Avatar
Soultrader Soultrader is offline
Founder of TL!

Trader Specs
 
Join Date: Aug 2006
Location: Tokyo, Japan
Posts: 2,856
Thanks: 56
Thanked 276 Times in 106 Posts
Blog Entries: 9
Send a message via MSN to Soultrader Send a message via Skype™ to Soultrader
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 Images
File Type: jpg spreadsheet1.jpg (136.4 KB, 36 views)
File Type: jpg spreadsheet2.jpg (123.1 KB, 37 views)

__________________
James Lee
Email: JamesLee@traderslaborator y.com
Skype: james.lee03
TradersLaboratory.com

Reply With Quote
  #3 (permalink)  
Old 09-30-2006, 03:27 AM
carter carter is offline
Registered Trader

 
Join Date: Sep 2006
Location: Boston
Posts: 53
Thanks: 0
Thanked 0 Times in 0 Posts
Re: Daily Analysis Spreadsheet?

Quote:
View Post
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.

Reply With Quote
  #4 (permalink)  
Old 09-30-2006, 02:30 PM
Maverick Maverick is offline
Registered Trader

 
Join Date: Sep 2006
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
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?

Reply With Quote
  #5 (permalink)  
Old 09-30-2006, 02:38 PM
Soultrader's Avatar
Soultrader Soultrader is offline
Founder of TL!

Trader Specs
 
Join Date: Aug 2006
Location: Tokyo, Japan
Posts: 2,856
Thanks: 56
Thanked 276 Times in 106 Posts
Blog Entries: 9
Send a message via MSN to Soultrader Send a message via Skype™ to Soultrader
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.

__________________
James Lee
Email: JamesLee@traderslaborator y.com
Skype: james.lee03
TradersLaboratory.com

Reply With Quote
  #6 (permalink)  
Old 10-01-2006, 07:11 AM
namstrader namstrader is online now
Premium Trader

 
Join Date: Sep 2006
Posts: 97
Thanks: 118
Thanked 17 Times in 2 Posts
Re: Daily Analysis Spreadsheet?

Soultrader,

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

Reply With Quote
  #7 (permalink)  
Old 10-01-2006, 07:24 AM
Soultrader's Avatar
Soultrader Soultrader is offline
Founder of TL!

Trader Specs
 
Join Date: Aug 2006
Location: Tokyo, Japan
Posts: 2,856
Thanks: 56
Thanked 276 Times in 106 Posts
Blog Entries: 9
Send a message via MSN to Soultrader Send a message via Skype™ to Soultrader
Re: Daily Analysis Spreadsheet?

Quote:
View Post
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.

__________________
James Lee
Email: JamesLee@traderslaborator y.com
Skype: james.lee03
TradersLaboratory.com

Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

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 02:34 PM.

 


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59