Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 5/6/2005(UTC)
Posts: 52
Location: England
|
Ive written an exploration, with results in colb,c & d. What Id like to do in Cola is enter dates. I know how to do DayofMonth() in one col, Month() in another and Year() in another. Infact Ive been using this on its own and scanning prev exploration results to get dates. Trouble is this is spread over 3 cols, so when exporting results to Excell I have to combine the cols to get the date. Not easy. Is there a way to have the data in one col.
Reegars Robert
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 1/19/2005(UTC)
Posts: 1,065
Location: Koh Pha-Ngan, Earth
Was thanked: 2 time(s) in 2 post(s)
|
Ok, how about something like this exploration:
[code:1:44178b2498]
ColA: date
---8<-----------------------
{ Last active trading date }
{ User inputs }
format:=1; {Date format: [1]0.yymmdd, [2]ymmdd, [3]ddmmyy}
idx:=1; { [0]Zero-Volume Indices, [1]Volume data}
{ Date components }
y:=If(Year()<2000,Year()-1900,Year()-2000);
m:=Month();
d:=DayOfMonth();
{ Date in selected format }
yymmdd:=y*10000+m*100+d;
ptyymmdd:=yymmdd/1000000;
ddmmyy:=y+m*100+d*10000;
date:=If(format=1,ptyymmdd,
If(format=2,yymmdd,ddmmyy));
{ Extend date from last active date }
{ Ignores zero-Volume - for use with padded data }
xtDate:=ValueWhen(1,V>0,date);
{ Last active date }
If(Idx=1,xtDate,date)
---8<-----------------------
[/code:1:44178b2498]
jose '-)
http://metastocktools.com/#metastock
.
|
|
|
|
|
|
| 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.
