Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 4/4/2008(UTC)
Posts: 10
|
Hi!
I want to using the explorer to search thru all stocks to find ROC montly.
For example Colname: January
25,2%
Colname: Februar
50%
And so on...
Can someone help me?
I have found the ROC code, but I must define the month.
Norwayturtle
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 11/7/2005(UTC)
Posts: 602
|
use month() and year() functions along with your calculations ought to do it.
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 4/4/2008(UTC)
Posts: 10
|
For example:
{January}
Month() =1;
Can you give me an example,please?:)
|
|
|
|
|
|
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)
|
norwayturtle,
There are more working-with-dates codes and examples on the forum to sink the proverbial ship. Do a search and see if you come up with something which suits your requirements; if not, find something that is close to your requirements and modify it for your own purposes. As always, if you get stuck, post your best attempt here and someone will assist.
I would also spend a little more time considering exactly what you mean by monthly ROC; the difference between the first bar of the month and the last bar of the month? (For explorations, use monthly charts and compute the difference between open and close). Or do you need the change between the highest price of the month to the lowest of the month, or lowest of the month to the highest of the month depending on what time-order the events happened, which you cannot use monthly charts for in the exploration.
wabbit [:D]
|
|
|
|
|
|
| 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.
