Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 2/27/2006(UTC)
Posts: 6
|
I want to sort all CLOSE prices in asscending order using external function in DLL. Please, help me to write code for this DLL.
How to do this in MS?
|
|
|
|
|
|
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)
|
Allvenis,
Please do not post your questions in multiple locations.... it only serves to annoy people.
Firstly, are you trying to sort one stock's closing prices in ascending/descending order? Or are you trying to sort the closing prices for all stocks in a particular time frame?
If the first, then why? It seems like a pointless task - but if you must, the easiest way would be to export the data to Excel and sort the data there.
If the second, then I suggest you create an exploration to facilitate the sort.
All of the answers on how to do this are in the MS Users Manual that is shipped with all legitimate copies of the software.
Hope this helps.
wabbit :D
P.S. Please delete your other post asking this same question.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 2/27/2006(UTC)
Posts: 6
|
To wabbit
I'm trying to sort one stock's value's (CLOSE/Ref(CLOSE,-1))-1) (I wrote closing prices 'cause it is easier to undestand what I want) in ascending order using my Indicator that I wrote in MS. Why? I want to get Historical VAR for every stock.
Excell is not good solution for me. I don't want to use it at all 'cause it takes a lot of time.
So what is your suggestion?
|
|
|
|
|
|
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)
|
OK... first off you will need the MSDK (which I assume you have)
Will you require to plot the VAR on the chart, ie will you need to return the VAR value from an external function for plotting or use by another indicator/function? Or, do you just want to access all of the stock data files, compute the VAR and store these values in another location for "offline" use?
The first will require the construction and compilation of a .dll file. This is no easy task and will be quite time and HD intensive to compute this 'on the fly' for each stock (but its not impossible!) My C++ skills are a little rusty as I haven't written anything for a while (too busy in Java and VB) but I imagine you need to read the entire data series into an array, use the sort() function in the <algorithm> part of the STL library into a second array, then massage the numbers as required.
The second is the easier, use the MSDK to write a request to the MS data, sort process and write to an output file.
Sorry I couldnt be of more use tonight. Username: brussel is one of the MS software developers and may be able to get you further down the right path than I. Failing that, there is always the MSDK Users Manual (which I seem to have mislaid? - its in this pile of junk somewhere!??)
wabbit :D
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Allvenis-
Please read the forum rules. Multiple posts of the same subject are considered SPAM and are prohibited. If your original post was not clear, then you have the option to go back and edit it. Since you have multiple people responding to you now in multiple threads, you probably want to give some feedback to those kind enough to volunteer their time to your original question. Again, read the forum rules.
As far as your comment goes regarding the time it will take to perform simplistic functions in Excel, it will be nothing compared to the time it takes to code an external dll. Even if you compare long term time savings, an automated Excel process should be very quick (and a lot less time consuming than writing a dll).
Custom programming solutions are generally sold to the interested party by a programmer. Perhaps this is an avenue that you might pursue.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 2/27/2006(UTC)
Posts: 6
|
To g_stockman
If I did something wrong, I really apolligize for my mistakes but I don't really understand where did you see the same multiple posts? If you see multiple posts with the same subject please, post them here and I will edit them or show you the difference.
Actually, I have solved my problem by myself ... Thank you for your advices =D>
P.S. I understand that you guys know only simple things from MetaStock manual that I already read, but I asked professionals to solve my problem.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Quote:P.S. I understand that you guys know only simple things from MetaStock manual that I already read, but I asked professionals to solve my problem.
Wow... you really should get to know the forum members a little better. Some of them are integral parts of the design, education, implementation, and support of the Equis line of products. Can't think of a better description of 'professional' than that.
|
|
|
|
|
|
| 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.
