NeoTicker Forums  

Go Back   NeoTicker Forums > Trading Related > Trading Techniques
User Name
Password
Register FAQ Members List Calendar Mark Forums Read

Reply
 
Thread Tools Rating: Thread Rating: 115 votes, 5.00 average. Display Modes
  #1  
Old 01-03-2006, 10:25 AM
forum's Avatar
forum forum is offline
Administrator
 
Join Date: Sep 2003
Posts: 1,077
TICK 16 - The Next Generation of TICK Index

This thread is for discussing Lawrence's article TICK16 - The Next Generation of TICK Index.
Reply With Quote
  #2  
Old 02-03-2006, 10:29 PM
Kel108's Avatar
Kel108 Kel108 is offline
Regular User
 
Join Date: Nov 2005
Location: Fairfield, Iowa
Posts: 193
Proxy for SP500

Since my subscription to esignal limits me to 500 symbols I was wondering if anyone in this situation used a proxy - for instance taking out the 10-15 least weighted symbols from the neoticker file that loads the symbols....I recently contacted S&P about this and they won't provide the weights unless you subscribe to their service. Is anyone doing this? I suppose even this way would be better than using $TICK based on the NYSE.
Reply With Quote
  #3  
Old 02-06-2006, 11:29 AM
Lawrence Chan Lawrence Chan is offline
Moderator
 
Join Date: Sep 2003
Posts: 2,358
Try using the OEX version - because OEX contains exactly the top 100 symbols in SP500.
Reply With Quote
  #4  
Old 04-15-2006, 11:54 AM
enflow enflow is offline
Junior Member
 
Join Date: Mar 2006
Posts: 35
Smile

Quote:
Originally Posted by Kel108
Since my subscription to esignal limits me to 500 symbols I was wondering if anyone in this situation used a proxy - for instance taking out the 10-15 least weighted symbols from the neoticker file that loads the symbols....I recently contacted S&P about this and they won't provide the weights unless you subscribe to their service. Is anyone doing this? I suppose even this way would be better than using $TICK based on the NYSE.

1. You can subscribe to more symbols but you probably know that - i am just trying to be complete... i have a subscription to 1200 symbols...

2. You can work out the cap weights for any sp stocks with the DDE info that esignal provides...

a. Create a column of symbols for the 500 symbols for last price (winros|last!XYZ)

b. Copy that column into the a new column to the right - replace the word last in the DDE formula with the word shares (winros|shares!XYZ) using the replace function in the edit menu - which is an easy way to do it fast - in one shot 15 seconds...

c. Create a formula column (call it Cap Value) whose result is a multiple of the last price of each sp500 stock by its outstanding shares (last * shares) = cap values

d. Also sum total that colunmn (Cap Value) at its bottom (cell 501) = equals the total cap value of the whole sp500 at that moment

e. Now you have the cap value of each 500 stock and the total cap value of all 500 stocks... divide the cap value of each stock into the total sp500 cap value to derive weights...

f. You can do this for any index that is cap weighted...

cj
Reply With Quote
  #5  
Old 04-17-2006, 09:46 PM
StatArb StatArb is offline
Regular User
 
Join Date: Feb 2006
Posts: 32
welcome edgehunter .
Reply With Quote
Reply


Thread Tools
Display Modes Rate This Thread
Rate This Thread:

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 Off
HTML code is Off
Forum Jump


All times are GMT -4. The time now is 12:16 PM.


Powered by vBulletin Version 3.5.2
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Copyright© 2000-2010 TickQuest, Inc.