|
|
|
|
|||||||
| Trading Indicators Post your custom trading indicators. If you download, remember to click INSTALL. |
![]() |
| Bookmarks | |||||||
del.icio.us
|
StumbleUpon
|
Google
|
Digg
|
Facebook
|
Furl
|
Reddit
|
Netscape
|
|
|
LinkBack | Release Tools | Display Modes | Language |
|
Excel Help Needed
Developer Last Online: May 2008
I am trying to get my Excel to mimic this post from Brett Steenbarger but have been unable to.
I was hoping some our programming experts might be able to help. The programming part needed is:
Guess that depends on how much Excel you know. Any help would be appreciated as always. |
||||||||||||||||||||||||
|
Show Your Support
|
||||||||||||||||||||||||
|
|
||||||||||||||||||||||||
|
By
thrunner
on
04-16-2008, 08:59 PM
|
||||||||||||
|
Re: Excel Help Needed
Sorry, don't really program Excel but here is a link for doing Pearson correlation in Excel: http://www.mnstate.edu/wasson/ed602calccorr.htm
However, correlation of multiple data series is fairly easy in Tradestation EL. One can import more data points and additional data series as well (such as the other sectors). ![]() re: code for TS Correlation: Insert 15 min chart SPY as data 1, XLF, XLE, XLY, XLP as data 2,3,4,5 respectively. You will need real time subscription if you are using TS for mixing these data. MC doesn't complain as much about these data. Then apply the following indicator (name it Correlation4 for example):
|
||||||||||||
|
Last edited by thrunner; 04-16-2008 at 10:08 PM.
|
||||||||||||
|
By
brownsfan019
on
04-16-2008, 09:59 PM
|
|
Re: Excel Help Needed
th - thanks!!
Can you post the EL that goes with this that you mentioned? I have MultiCharts and can import into that. Thanks! Any other takers? ![]() |
|
By
brownsfan019
on
04-17-2008, 12:34 AM
|
||||||||||||
|
Re: Excel Help Needed
I got an email back from Brett with this explaining how to do in Excel:
Ummm... ok..... ![]() Thanks to thrunner for the TS code! I will try in MC tomorrow. I would also like to get the Excel sheet working as well for anyone that can help figure this '5 minute' project out... THANKS |
||||||||||||
|
By
darthtrader
on
04-17-2008, 09:17 AM
|
|
Re: Excel Help Needed
I think this is where you really want to learn some basic VBA if you really want to work with excel like this. I've been contemplating this but just haven't got around to learning it.
For a straight out spreadsheet it shouldn't be too bad though, just alot of columns. Subtract A2 from A1 to get the 15 minute change in price. Once you have those make the columns for all the correlations and use the CORREL function , ie =CORREL(A1:A27, B1:B27). Once you have those make one more column, add the six correlation values across and divide by 6. |
![]() |
| Currently Active Users Viewing This Release: 1 (0 members and 1 guests) | |
| Release Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Release | Release Starter | Category | Comments | Last Post |
| MP on excel | gomes | Market ProfileŽ | 114 | 02-03-2008 04:04 PM |
| Market Profile in Excel | winnie | Market ProfileŽ | 5 | 01-31-2008 11:13 AM |
| Trading Strategy in Excel. | TheJudge | Beginners Forum | 1 | 12-06-2007 07:49 AM |
| Technical analysis in Excel | TheJudge | Beginners Forum | 2 | 11-06-2007 06:47 AM |
| Interesting Excel Sheets | TinGull | General Discussion | 2 | 03-23-2007 04:46 PM |