Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 4/15/2009(UTC)
Posts: 2
|
Hello to all!
I have a question about upload and test data in MS10.
I have three time series data from a table of quotations to some stocks (or futures) in text format. P(t) is the market price, TD(t) is the total demand, TS(t) and total supply at the current time t, where t=0,1,2,.....
The hypothesis is as follows.
The price has the strong change (up or down) at the convergence of supply and demand curves.
I want to find the optimal size and the number of Delta=abs(TD(t)-TS(t)), t=0,1,2,.... for the strong price changes and to test my hypothesis statistically on historical data in the MS10.
Function abs() is absolute value of substraction TD(t) and TS(t).
I know about the testing changes of prices with Bollingers Bands (Top and Bottom) and think that it's may be close with my task.
How can I download data to MS10 and to test their in tester?
Can somebody help me with my task?
|
|
|
|
|
|
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)
|
Read the section in the MS User Manual on OLE (Object Linking and Embedding) to show Excel data in an MS chart.
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.
