Rank: Newbie
Groups: Registered, Registered Users, Subscribers Joined: 1/23/2006(UTC) Posts: 3
|
Dear Forum Moderators and Admins,
I have some questions and I need your help to get it done.
1) I want an exploration to get a list of all stock data array (C,H,L,V) in the last dealing day
2) How can I get the last dealing day in a security?
3) a simple exploration result with simple formula with no filter, give result different from result in the chart
for example, a exploration with one column with RSI(14) as a formula the last result of this will exploration is not the same as the one in the chart , why is that?
Looking forward for your usual support,
Thank you for your effort in this helpful forum
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 3/7/2005(UTC) Posts: 1,346
|
hey market sa.... the only reason that comes to mind regaurding rsi would be if the rsi(setting) differed from the one used in chart and the exploration.... if both were rsi(14), results should match the chart.... as far as the last dealing day, the exploration will return the last day in each securities data file as is...... the open/close/high and so on, just put one in each column.... holler back if ya don't follow.....h
Exploration notes
Col A: O
Col B: H
Col C: L
Col D: C
Col E: V
Col F: RSI(14)
Filter enabled Yes
Periodicity Daily
Records required 4000
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users Joined: 3/19/2005(UTC) Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Hey marketsa-
To get the list of the array, set up the explorer in different columns
A Open
B High
C Low
D Close
Make sure you load (explore) the same security that you are viewing. The numbers should match exactly.
e.g., For the previous day, choose ref(Close, -1) or ref(C,-1)
When you are using RSI, make sure you are comparing apples to apples... Try plotting just a plain old RSI(14), then run your exploration using the same. Again, the numbers should match exactly.
You could enter this on an advisor and see it too:
The current close is writeval(C).
Yesterday's close was writeval(Ref(C,-1)).
The current RSI is writeval(RSI(14)).
Yesterday's RSI was writeval(ref(RSI(14),-1)).
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users Joined: 3/19/2005(UTC) Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Oops... guess H beat me to it... oh well...
Morning H! :bye:
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 3/7/2005(UTC) Posts: 1,346
|
morning g.... i was just gittin ya back, you do that to me all the time, wabbit used to also.... he must be on another of his outback-walk-abouts huntin red deer , walabees or somethin..... h
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Subscribers Joined: 1/23/2006(UTC) Posts: 3
|
Thanks gentlemen for your responses.
I found out that I'm doing fine and I think I found the problem.
MS is skipping the weekends (Saturday and Sunday). In my country, the weekend is Thursday and Friday.
How can I force MS to consider all days, thanks again for your help and efforts.
Market_Sa
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 3/7/2005(UTC) Posts: 1,346
|
hey market sa.... seems like someone from the uae countries asked that before but can't remember the outcome.... you might try tools->options->chart options, then check off 'show empty weekends'.... can't think of anything else off hand..... still studying.....h
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Subscribers Joined: 1/23/2006(UTC) Posts: 3
|
hayseed : I have read it somewhare, but this will make MS consider weekend in the chart but not in exploration.
I have read that it is a bug in MS 8 and this bug was resolved in MS9.1 , can you varfy that please.
regards,
|
|
|
|
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.