Discussions
»
Product and Service Development
»
Formula Assistance
»
Continued interest in custom index function [RESOLVED]
Rank: Newbie
Groups: Registered, Registered Users Joined: 8/26/2005(UTC) Posts: 7
|
so i'm trying to write a custom index and I know how to use the security function... the problem is that it doesn't produce a weighted average of the individual securities in the index, it just adds up the close (or whatever data array you choose). I've figured out the long way to produce an index comprised of the weighted average of the individual issues:
vintc:= Security("c:\\Prophet\\data\\i3\\INTC",C) / (Security("c:\\Prophet\\data\\i3\\INTC",V) +
Security("c:\\Prophet\\data\\i3\\IMGN",V) +
Security("c:\\Prophet\\data\\i3\\IDBE",V));
(repeat for other securities)
vintc * Security("c:\\Prophet\\data\\i3\\INTC",C) +
vimgn * Security("c:\\Prophet\\data\\i3\\IMGN",C) +
vidbe * Security("c:\\Prophet\\data\\i1\\IDBE",C)
but this is not what i'm looking to do :( (especially considering i'm looking to make custom indices of all the major industries, which require updating probably every quarter for symbol changes and whatnot...) I want a SIMPLE solution...
i was reading patrick's (?) old post about designing a patch that allows the user to put securities into a folder and the program automatically calculates the index from the securities in that folder... if he could make that the weighted average of the issues (just like the nasdaq and all the other major indicies are), then i'd be willing to pay for such a patch....
maybe not 2g's but... we can negotiate...
also, i'd like to be able to display the index by itself as a separate chart, to which i can apply various tech indicators such as MA, MACD, RSI, etc.
Right now, the index made from the security function can only be displayed on top of another chart :x ... me no like-ey!!
how about it p? you up for this?
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users Joined: 8/26/2005(UTC) Posts: 7
|
oops!!!
that first line of code should be:
vintc:= Security("c:\\Prophet\\data\\i3\\INTC",V) / (Security
not C; the weighted average using volume to weigh the individual issues contribution to the index...
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 9/8/2004(UTC) Posts: 2,266
Was thanked: 1 time(s) in 1 post(s)
|
Well I'm working on it here and there ;)
Just keep an eye on the Dll Function forum ...
Patrick :mrgreen:
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users Joined: 8/26/2005(UTC) Posts: 7
|
much obliged sir :D
Peter
|
|
|
|
Users browsing this topic |
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
Formula Assistance
»
Continued interest in custom index function [RESOLVED]
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.