|
PureBytes Links
Trading Reference Links
|
Leo:
Can a macro be used to speed up this tedious task?
Lionel
-----Original Message-----
From: leo <leo@xxxxxxxxxxx>
To: metastock@xxxxxxxxxxxxx <metastock@xxxxxxxxxxxxx>
Date: Thursday, November 05, 1998 10:52 PM
Subject: Europeen Currencies
>Good Morning,
>
>On January, 1, 1999, the currencies will change in different European
>countries, and so the values of stocks. We'll be in the situation to
>trade on Thursday 31 1998 with the old countries currencies, and we'll
>shift to Euro during the week end to trade with Euro on Monday 4 1999.
>Unfortunately, we don't know the precise rate of change today and we'll
>know the rate on the last days of december, so we have only the last
>1998 week end to perform the database conversion.
>
>This is not a big problem, except that Metastock has not now the tools
>to make these changes easily on the stock database.
>Metastock downloader has only an adjust manual function that permits to
>manually change all the values ( High, Low, Open, and close ) of a
>particular stock. So it is easy to change a particular stock FF, FL,
>Li, Mark, or else .... into Euro.
>
>The problem is that this tool can operate on only one stock at the same
>time. So to convert the database, you have to duplicate the manual
>change you make on each stock.
>To unfold the tediousness or tiresomeness of the task, I take an example
>of a database of 1000 stocks ( 10 folders with 100 stocks in each ). If
>it takes 30 seconds to make the changes on one stock, you'll use
>approximately 8 hours to make the all changes of the all database and if
>you have the willingness to endure this way, you ended with a big
>headache as a gift.
>
>A suitable solution to this problem is that Equis realize the piece of
>software to achieve this manual function for all the stocks of a
>particular folder. It is not a difficult software to make, it's just a
>loop on an current function and for me its realization cost is very
>weak.
>To retake the last example of 1000 stocks located on 10 folders , with
>this new function, you'll only use 6 minutes to make the complete change
>on the database without headache this time and you also can drink a cup
>of coffee during the database conversion.
>
>Unfortunately, I don't understand the reasons, it seems that Equis is
>not decided to implement the Euro function.
>
>So, what are the other alternatives ?
>
>Has somebody a useful solution for the Euro conversion ?
>
>I thank you very much.
>
>Best Regards.
>
>Robert Vialet
>
>
|