logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Sent74  
#1 Posted : Saturday, December 15, 2007 7:10:40 PM(UTC)
Sent74

Rank: Newbie

Groups: Registered, Registered Users
Joined: 9/16/2007(UTC)
Posts: 1

Hi, Pls help me with a formula to find the start date of the a metastock file. Regards Senthil
hayseed  
#2 Posted : Sunday, December 16, 2007 8:11:55 PM(UTC)
hayseed

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 3/7/2005(UTC)
Posts: 1,346

hey senthil...... do you actually need a formula .....

not really sure just what your doing with the first date, but you can tell the first date when you open any security...... it shows first and last date for every security in the folder..... that might not suffice but is one way.....h

Richard Dale  
#3 Posted : Monday, December 17, 2007 12:18:05 AM(UTC)
Richard Dale

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 4/5/2006(UTC)
Posts: 129
Location: Norgate Data

Try these out:
startyear := ValueWhen(1,Cum(1)=1,Year());
startmonth := ValueWhen(1,Cum(1)=1,Month());
startdom := ValueWhen(1,Cum(1)=1,DayOfMonth());
Note that when you use an exploration, make sure you have the max number of periods loaded (eg. 65000) in the Options.

Cheers,
Richard.


Cheers, Richard Norgate Data
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.