Rank: Member
Groups: Registered, Registered Users
Joined: 10/6/2008(UTC)
Posts: 15
|
i would like to calculate data some thing using a fixied data on a specified date
like i would like to caluculate something like momentum but insteade of using ref(c,-5)
i want to : c-ref(c,at 1/jan/2008) so
it will keep on calculating the today's close minus the close of 1/jan/2008
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
Hi hatem,
Welcome to the forum.
Have a look in the MS Users Manual and/or the free Equis Formula Primer for the ValueWhen() function. Do a search of the forum for working with dates. If you have any problems, post your best attempt at your code and someone will help.
wabbit [:D]
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users
Joined: 10/6/2008(UTC)
Posts: 15
|
thank you for the quick reply,
i have tried looking through the fourm but i did not find the answer , also have tried ValueWhen but that is not what i am looking for,
what i want is : everyday's close over original date say 1/jan/2009
: say for example that i have
Day Close
1/jan/2009 23
2/jan/2009 25
3/jan/2009 21
4/jan/2009 26
so now i will calculate everynew day's close above original (fixed)day close, (note the date is the important not the value)
so i will calculate the Div of every day over the original day
23/23
25/23
21/23
26/23
i hope now it is clear ,
thanks anyway
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users
Joined: 10/6/2008(UTC)
Posts: 15
|
thank you very much, that was really helpfull
now i wonderr if you can help me one more time,
i am looking for the zigzag formula
i donot mean the ZIG(c,10%)
i mean how to write it from the scratch
thanks
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users
Joined: 10/6/2008(UTC)
Posts: 15
|
hatem wrote:
thank you very much, that was really helpfull
now i wonderr if you can help me one more time,
i am looking for the zigzag formula
i donot mean the ZIG(c,10%)
i mean how to write it from the scratch
thanks
hi why you are not answering me,
if there is something wrong you should tell me so i would not waste my time waiting,
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
Gee sorry hatem, next time I want to go away for the weekend with my friends, I shall seek your permission first.
No-one here works on the forum full-time. Posts are answered by the volunteers and other members who are under no obligation to answer posts in the first place.
wabbit [:D]
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users
Joined: 10/6/2008(UTC)
Posts: 15
|
This is really childish talk,
Grow up
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
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.
