|
PureBytes Links
Trading Reference Links
|
See attached old email to the List on this subject.
Open in mail program
- or save to disk as an TXT file(" .txt ")
- or just save as is, then go to this saved file, change its name extension
from " .eml " into " .txt " and run/double click to open it in NotePad(WordPad).
Regards,
Ton Maas
ms-irb@xxxxxx
----- Original Message -----
From: Dave <dthomas@xxxxxxxxxxxx>
To: <metastock@xxxxxxxxxxxxxxxxxx>
Sent: zondag 1 november 1998 11:51
Subject: Portfolio Management
>How can I, on a daily basis, import the closing price of given shares into
>Excel so that I can monitor the current value of my portfolio?
>
>
Return-Path: <owner-metastock-outgoing@xxxxxxxxxxxxxxxxxxxx>
Received: from smtp01.wxs.nl ([195.121.6.61]) by po01.wxs.nl
(Netscape Messaging Server 3.52) with ESMTP id AAA65F;
Fri, 8 May 1998 19:27:55 +0200
Received: from freeze.metastock.com ([204.246.137.5]) by smtp01.wxs.nl
(Netscape Messaging Server 3.52) with ESMTP id AAA6B94;
Fri, 8 May 1998 19:27:13 +0200
Received: (from majordom@xxxxxxxxx)
by freeze.metastock.com (8.8.5/8.8.5) id KAA21945
for metastock-outgoing; Fri, 8 May 1998 10:30:55 -0600 (MDT)
X-Authentication-Warning: freeze.metastock.com: majordom set sender to owner-metastock@xxxxxxxxxxxxx using -f
Received: from smtp02.wxs.nl (smtp02.wxs.nl [195.121.6.60])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id KAA21934
for <metastock@xxxxxxxxxxxxx>; Fri, 8 May 1998 10:30:48 -0600 (MDT)
Received: from escom ([195.121.19.5]) by smtp02.wxs.nl
(Netscape Messaging Server 3.52) with SMTP id AAA5A1E
for <metastock@xxxxxxxxxxxxx>; Fri, 8 May 1998 18:24:45 +0200
Message-ID: <000a01bd7a9d$b0b5cac0$051379c3@xxxxx>
From: "A.J. Maas" <anthmaas@xxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Subject: Re: Portfolio Manager - Excel (Step-by-Step)
Date: Fri, 8 May 1998 15:41:24 +0200
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0082_01BD7A97.C19EC4A0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<META content='"MSHTML 4.72.2106.11"' name=GENERATOR>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT color=#000000 size=2>Yes!</FONT></DIV>
<DIV><FONT color=#000000 size=2></FONT><FONT size=2>Below is my reply to a
simular question(send on a couple of days ago).</FONT></DIV>
<DIV><FONT size=2>Thanks for yours and Harley's input into this
Excel-Portfolio-subject.</FONT></DIV>
<DIV><FONT size=2></FONT><FONT color=#000000 size=2>Regards,</FONT></DIV>
<DIV><FONT color=#000000 size=2></FONT><FONT size=2>Ton Maas</FONT></DIV>
<DIV><FONT size=2><A
href="mailto:Ms-IRB@xxxxxxxxx";>Ms-IRB@xxxxxxxxx</A></FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT
size=2>----------------------------------begin----------------------------------------------</FONT></DIV>
<DIV><FONT color=#000000 size=2></FONT> </DIV>
<DIV><FONT size=2>p 36-dl manual-create folders<BR>p 69-dl manual-traverse
folders<BR><BR>In win95-explorer, just make as many folders as you like,
then<BR>go to the dl, and "copy" the securities you need from one
folder<BR>to another<BR><BR>You can keep multiple copies too, and they too will
be updated,<BR>for this make sure in dl:<BR>-to press
"conversion"-button to go to "convert"-dialog<BR>-before
actual conversion, to go to its "options"-dialog<BR>-on the
"destination" tab - traverse folders must be marked/applied<BR>-click
ok and ok again on the "conversion options" tab to get
you<BR> back to the "convert-dialog":
<BR>General: folder to convert to can be just the "parent" folder, so
as the<BR>destination-folder: no need to type in the kiddies names(the sub+sub
subs)</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT
size=2>----------------------------------------end---------------------------------------------------
<BR></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><B>-----Oorspronkelijk bericht-----</B><BR><B>Van:
</B>Teo Soon Bock <<A
href="mailto:teosb@xxxxxxxxxxxxxx";>teosb@xxxxxxxxxxxxxx</A>><BR><B>Aan:
</B>metastock@xxxxxxxxxxxxx <<A
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A>><BR><B>Datum:
</B>vrijdag 8 mei 1998 3:41<BR><B>Onderwerp: </B>Re: Portfolio Manager - Excel
(Step-by-Step)<BR><BR></DIV></FONT>To Harley: If you take the securities in your
portfolio and copy them to a new sub-directory, would this sub-directory be
automatically updated whenever you download fresh data into your main data
directory?<BR><BR><BR>I wrote the following last year based on Singapore stocks,
but it could certainly be used for other markets as well:-<BR><BR><< QUOTE
>><BR>PORTFOLIO MANAGEMENT USING MICROSOFT EXCEL, LINKED<BR>TO METASTOCK
DATA BASE<BR><BR>For those of you who are using MetaStock 6.5 charting software
to do technical analysis of stocks and shares, it is possible to link the
MetaStock data base to Microsoft Excel for Windows 95 in order to have automatic
updating of your portfolio whenever the data base is updated by downloading the
latest data from your data vendor. <BR><BR>MetaStock 6.5 is able to create links
with other Windows 95 programs, eg Microsoft Excel, by using OLE (object linking
and embedding). The portfolio management spreadsheet uses OLE for automatic
updating of the profit/loss columns from the MetaStock charts.<BR><BR>The
following are the detailed steps for linking your selected MetaStock charts to
your portfolio management spreadsheet in Microsoft Excel for Windows
95:-<BR><BR>1. Action to be taken on the selected counters in <BR>MetaStock
6.5<BR><BR>(a) Open MetaStock 6.5 and click on Indicator Builder;<BR><BR>(b)
Create a New indicator named CLOSE, and under Formula, just type the word CLOSE.
Click on OK to save it. The creation of this CLOSE indicator needs to be done
once only, and can be applied to all counters.<BR><BR>(c) Open the chart for
your selected portfolio counter, eg DBS LAND.<BR><BR>(d) Drag and drop the CLOSE
indicator from your QuickList on to the chart.<BR><BR>(e) As this CLOSE
indicator is not used for normal chart analysis, you can hide it by making it
the same colour as the background (right-click on the CLOSE indicator, select
CLOSE properties, and under Color, choose white if your chart background is also
white).<BR><BR>(f) Repeat (c) to (e) for other selected counters for your
portfolio. You may want to test with a few counters first.<BR><BR><BR>2. How to
link your Excel spreadsheets to the selected counters<BR><BR>(a) Open Microsoft
Excel, and click on New workbook. In cell A1, type in the name of the counter
selected for your portfolio, eg DBS LAND.<BR><BR>(b) Switch to MetaStock 6.5,and
select the chart for DBS LAND. Click on the CLOSE indicator. (If your chart has
many indicators drawn on it, you can use the TAB key to help you select the
CLOSE indicator.) Once the CLOSE indicator is selected, click on Edit, followed
by Copy.<BR><BR>(c) Switch back to Excel, and click on cell A2, followed by
Edit, Paste Special, Paste Link as Csv, and OK. (Csv stands for "comma
separated values.") You will get a 2-column table with Date and CLOSE as
the header. The dates will be imported as raw numbers, and can be formatted
appropriately using the Format, Cells, Date command. The maximum number of
records is 1,000 in Excel for Win95; the minimum number of records will depend
on the Load Options (File, Open, Options) dialog box in MetaStock. You can now
save the file using the counter name, eg DBSLAND.xls<BR><BR>As stated above, the
maximum number of records in each of your Excel portfolio file may be 1,000
records (about 4 years). However, for new IPOs, the number of records that is
copied over will probably be less than 1,000. Nevertheless, it is important to
block off space for 1,000 records so as to allow for automatic linkage as more
records are added. The extra records will be marked with #N/A (not
available).<BR><BR>(d) Repeat steps (a) to (c) for the other selected counters
in your portfolio.<BR><BR>(e) The next step is to build up your main portfolio
spreadsheet file, and link it to the individual Excel files for your portfolio.
The rows in this spreadsheet will be the counter names, while the columns could
have headings like Date Bought, No. of Shares, Price Bought, Total Cost; Updated
Date and Price; Profit/Loss; Date Sold, No. of Shares, Price Sold, etc. You can
save your main portfolio spreadsheet with an appropriate name, eg
PORTFOLIO.xls<BR><BR>(f) The figures for the Updated Date and Price columns in
your main portfolio spreadsheet can be updated automatically from the individual
Excel files for the portfolio by using the VLOOKUP function in Excel. For
example, for the Updated Date cell for DBS LAND, just type the
following:-<BR><BR>=VLOOKUP(NOW(),[DBSLAND.xls]Sheet1!A2:B1002,1)<BR><BR>and for
the updated Price cell for DBS LAND, type the
following:-<BR><BR>=VLOOKUP(NOW(),[DBSLAND.xls]Sheet1!A2:B1002,2)<BR><BR><BR>The
above should be repeated for all the counters in your portfolio, with the file
name for the counter amended accordingly. It will even work for new IPOs where
the number of records is less than 1,000 records.<BR><BR><BR>3. How to keep your
portfolio files together so that all the individual portfolios can be updated at
the same time<BR><BR>(a) This is desirable so that when you open just one Excel
file, your entire portfolio can be updated at the same time.<BR><BR>(b) Open all
the Excel files for your portfolio, with your main portfolio spreadsheet as the
most recent file to be opened.<BR><BR>(c) Click on File, Save Workspace, and
save your file in the XLStart subdirectory of your Excel program, eg
C:\MSOffice\Excel\XLStart\port1.xlw<BR><BR>(d) In this way, whenever you start
your Excel program, your portfolio workspace file will be started automatically,
and when it prompts you whether to re-establish links, just click on Yes, and
your portfolio will be updated.<BR><BR><BR>. . . . .<BR><< UNQUOTE
>><BR><BR>At 10:10 PM 5/7/98 +0200, skystar wrote:
<BR>>>>><BR>
<BLOCKQUOTE><?smaller>Thank you Harley for your response to my question.
Being a novice I need more info. Please run me step by step once I have
opened the single bar in a new sub directory. Thank you.<BR>I see Roland is
also looking for help on this subject.<BR>Regards - Charles<?/smaller> <BR>
<BLOCKQUOTE><B><?fontfamily><?param Arial><?smaller>-----Original
Message-----<BR>From:<?/smaller><?/fontfamily> </B><?fontfamily><?param Arial><?smaller>Harley Meyer
<<mailto:meyer@xxxxxxxxxxx>meyer@xxxxxxxxxxx><BR><B>To:
</B><mailto:metastock@xxxxxxxxxxxxxxxxxxxx>metastock@xxxxxxxxxxxxxxxxxxxx
<<mailto:metastock@xxxxxxxxxxxxxxxxxxxx>metastock@xxxxxxxxxxxxxxxxxxxx><BR><B>Date:
</B>04 May 1998 04:25<BR><B>Subject: </B>Re: Portfolio Manager -
Excel<BR><BR><?/smaller><?/fontfamily>In a nutshell. Take your
securities in your portfolio and copy them to a new sub directory. Now
open them up but select the option for days loaded to be one day.
<BR><BR>OLE this single bar into Excel. Save as a smart chart.
<BR><BR>Now in Excel take the info you want and link it to it's final
resting place. <BR><BR>Harley <BR><BR><BR>skystar wrote: <BR>
<BLOCKQUOTE><BR>
<BLOCKQUOTE><B><?fontfamily><?param Arial><?smaller>--<?/smaller><?/fontfamily></B>
<BR><?fontfamily><?param Arial><?smaller><?/smaller><?/fontfamily><?smaller>I
would greatly appreciate it if someone/s could help me to
construct a porfolio manager in Excel that will update after
doing an end of day share price download on Metastock. I have
tried copying a line graph in Metastock and doing a "paste
special" "paste link" in Excel and I get the
entire share price history. What I want is only the end of last
day's trade date, volume, high, low and close to be updated in
the previous day's date, volume, high, low and close cells in
Excel.Thanks - CharlesUsing Metastock 6.5<?/smaller><?smaller>
<mailto:skystar@xxxxxxxxxx>skystar@xxxxxxxxxx<?/smaller>
<BR></BLOCKQUOTE></BLOCKQUOTE><BR></BLOCKQUOTE><BR></BLOCKQUOTE><<<<<BR><BR></BODY></HTML>
</x-html>From ???@??? Mon Nov 09 07:52:01 1998
Received: from listserv.equis.com (204.246.137.2)
by mail02.rapidsite.net (RS ver 1.0) with SMTP id 17852
for <neal@xxxxxxxxxxxxx>; Mon, 9 Nov 1998 10:49:37 -0500 (EST)
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id GAA11562
for metastock-outgoing; Mon, 9 Nov 1998 06:43:54 -0700
X-Authentication-Warning: listserv.equis.com: majordom set sender to owner-metastock@xxxxxxxxxxxxx using -f
Received: from freeze.metastock.com (freeze.metastock.com [204.246.137.5])
by listserv.equis.com (8.8.7/8.8.7) with ESMTP id GAA11558
for <metastock@xxxxxxxxxxxxxxxxxx>; Mon, 9 Nov 1998 06:43:51 -0700
Received: from smtp02.wxs.nl (smtp02.wxs.nl [195.121.6.60])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id GAA03148
for <metastock@xxxxxxxxxxxxx>; Mon, 9 Nov 1998 06:58:34 -0700 (MST)
Received: from escom ([195.121.38.164]) by smtp02.wxs.nl
(Netscape Messaging Server 3.6) with SMTP id AAA2EB9
for <metastock@xxxxxxxxxxxxx>; Mon, 9 Nov 1998 14:48:15 +0100
Message-ID: <015d01be0be7$5850e500$4f2779c3@xxxxx>
From: "A.J. Maas" <anthmaas@xxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Subject: Re: Europeen Currencies
Date: Mon, 9 Nov 1998 13:44:08 +0100
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.0810.800
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.0810.800
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
X-MIME-Autoconverted: from 8bit to quoted-printable by listserv.equis.com id GAB11562
X-Loop-Detect: 1
X-UIDL: 366bc635a9161965886384ee745349ca
True, I was only speaking from my own situation here, where I have a database with
-securities with the Volume given and
-securities with the Volume-coloms cells constant at "0" as their record
That is for Valuta and Indexes securities mainly.
Most Stock securities and only some Indexes securities here are equiped with the
real Volume records(uppose to the fixtious "0").
For this 2 different macros would then have to be made, of which the "Split" version
would be the easiest and quickest to be made, and a "Manual" version as its second.
Also once made you will get the hang of it and like mentioned before, you will then
be able to write macro's for every kind of computing session in any kind of program.
And that comes in handy when you are frequently computing.
I have learned this at first, by starting out to write simple DOS-batch files, only to hold
up about 1-15 lines, of which each line is a command line.
These command lines are then the same commands(lines) that you could type in
the "Run"-Dialog Window when you click "Start|Run" on the Windows Taskbar.
1. When typing in its "Run|Open" tiny window, all the nescessary Parameters can be
added at the right-end of the command.
2. This WinCron works the same way with the " $ " character only to be added to it upfront,
right at the first, to be typed in with that character at the beginning-left side.
Click "Notepad|New" to type on each of its lines what normaly is to be typed as in #1+2.
Then save as " testEURO.bat " and do this as a test run on some spare-copied-securities.
You will soon notice what went wrong as most of Metastock's programs commands
are accesable with the key-strokes commands, in the friendly Windows environment.
So anything resulting from that, that is done wrong, is caused by users inputs, eg wrongly
typed command-lines.
Metastocks + Excels Formula Languages work the same way, also with plenty of extra
guidence from their extensive Helpfiles and manuals.
Plus you do not have to learn yet again another language, as you are using Win95's own
commands system, which stems from the old DOS program.
As such, plenty is documented on it, to learn it the easy way.
WinCrons Help file is kept small, so as to not have to confuse its user, and being such a
simple command-language, it doesn't require that much Help.
Nearly every command that is available is fully explained and its examples are well given.
Reg.
Ton Maas
----- Original Message -----
From: leo <leo@xxxxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: zondag 8 november 1998 23:55
Subject: Re: Europeen Currencies
Good Morning,
I've appreciated your advice and your explanations how to use macro to convert the different currencies in
Euro. It seems to be a good idea. However, it's not possible to use the split function because the split
function changes the value of the volume. The volume has to be the same after the conversion. The only
modifications are on the price. It seems to me that it's possible to use the same macro method with the
manual adjust function.
The only problem is to give few days to learn the macro generator, because the product's usage doesn't
seem easy. The best solution will be that Equis realizes a function that permits to convert all the
securities of a folder. If Equis refuses, to learn the macro language will be , may be a good invest for
the future tasks.
Thank you for your help
Robert Vialet
A.J. Maas wrote:
> Splits over multiple folders/securities should be made possible in the Downloaders "Split" Tool.
> In that I agree with you wholeheartly.
>
> However in this "To have the 1000 secs adjusted for the EURO" being only a 1 time event, then
> use any of the -in MS desperatly missing- macro programs or if not available in your arsenal of
> programs, then in the Downloader and manualy :
> -Open the MAXIMUM allowed securities to be opened in 1 session(usualy this would
> be 6 securities
> -Click the "Adjust" tool menu on the work menu's top bar
> -Now do not click the "Manual" adjust-tool, but use the "Split" adjust-tool
> -Apply the fixed EURO conversion rate, as will be set on 19990101, in the tiny Ratio window
> -Right click this Ratio factor and click to copy it to the clipboard for the next securities
> that are to follow or
> -Press "Ctrl+C" to have this ratio copied stored in the temp memory, eg the clipboard
> -Then Paste each time as is required using right clicking the new securities Ratio window
> over and over again and Paste or use "Ctrl+V"
>
> Now you can semi-automatically adjust 6 securities at one time and this then will leave
> you up to do this split adjusting in only 167 sessions (1000 secs / 6 secs per session = 167).
> One session takes up roughly 2-3 minutes, at the most, to complete when this is done
> physically by hand and 1-1.5 minutes, or less, when auto done using a macro program.
> -Run C:\Equis\Dlwin\Downloader.exe
> -Wait seconds/window
> -Alt+F to click "File"
> -O to "Open" a security
> -Alt+Z plus arrow Up or Down plus Enter to open the right folder
> -TAB plus TAB plus arrow Up or Down to select the right security and Enter or
> -"Shift" plus arrow Down plus arrow Down to select multiple securities
>
> etc. etc.
> Most of the underlined letter charcters that are seen within windows can be selected(also manualy)
> with holding the "Alt" key down and hitting the according letter. Same goes when "Ctrl" has to be used
> or like in the Downloader, you sometimes will have/can to omit these Main keys.
>
> Note that a macro program that is able to send Key-strokes, can do all of this "manual by hand"
> stuff without having to leave or to shut down or to ex+import from the Downloader. It just replaces any
> of the mouse-clicks you normaly do by hand, by sending to the Downloader program its equivelant
> key-strokes, eg Alt-A etc.
> >From experience I do not recommend to use any "recorded" mouse movements, as these are fixed
> on the possible not applicable anymore previous mouse positionings.
> Key-strokes are the best way, and when you do get aquinted with this way of automatationg, you can
> then apply other new made macros on the other frequently returning jobs.
>
> Test these macros out on some securities you have made a spare copy from at first, tho.
> Every start is not easy and this is just to be on the safe side.
>
> Overall it takes you only one day out of your live to later having had the pleasure to have got
> rid of the morbid old hat currency differences on the one EURO continent.
>
> Macroing programs are available for FREE, here is the address for the free, tiniest and Worlds
> best macro program "WinCron1.3"(or see this program attached in previous mail with as
> subject, you gessed it "Re: World's Best Macro Program"
>
> WinCron1.3
> sgray@xxxxxxxxxxxxxx
> http://www.ryerson.ca/~sgray
>
> Regards,
> Ton Maas
> ms-irb@xxxxxx
>
> =============================================================
> Split
>
> The Split command is used to adjust the price data and volume for a stock split.
> A company usually splits its stock (often 2 shares for 1) in order to decrease the
> price, thereby increasing its liquidity.
> The Split command cannot be selected if a composite is displayed in the datasheet.
> Composite price data cannot be edited or adjusted directly (see Opening a Composite).
> Please use caution when applying this command. Once an adjustment is made, it may
> be difficult to bring the data back to its original state.
>
> You are prompted to enter the range of data by typing the first and last dates to split.
> -First Date. This is almost always the first date in the datasheet or the first date in the
> selected data panes.
> -Last Date. This is the day before the security's price changed.
> -Ratio. The default split Ratio amount is automatically calculated based on the change
> in the security's price following the split (e.g., 2 for 1, 3 for 2, etc.).
>
> When a stock splits, the historical prices must be adjusted to reflect the split.
> For example, if XYZ company has a 2 for 1 stock split, shareholders will receive two
> shares for each share that they own. To keep the total market value of the stock equal,
> the price per share is reduced by one-half. Therefore shareholders will have twice as
> many shares at half the price.
> Stock splits are usually done in order to increase the liquidity of the stock.
>
> When price data is adjusted for a stock split, the volume is also affected.
> For example, in a 2 for 1 split where prices are cut in half, the volume is doubled so that
> the market value remains unchanged.
>
> To adjust data for a split:
>
> þ Choose Open from the File menu (or select an open datasheet).
> þ Select the security to adjust. The datasheet will appear.
> þ Choose Split from the Adjust menu.
> þ Type the First Date, Last Date and the Ratio of the split.
> Remember, the First Date is the first date in the datasheet; the Last Date is the day
> before the security prices changed.
> þ Click the OK button.
>
> To adjust data for a split using the right-click commands:
>
> þ Choose Open from the File menu (or select an open datasheet).
> þ Select the security to adjust. The datasheet will appear.
> þ Select the desired date range to adjust.
> þ Right-click on the selected area and select Split from the pop up menu.
> The command's dialog will appear displaying the selected date range.
>
> ==============================================================
>
> -----Oorspronkelijk bericht-----
> Van: leo <leo@xxxxxxxxxxx>
> Aan: metastock@xxxxxxxxxxxxx <metastock@xxxxxxxxxxxxx>
> Datum: vrijdag 6 november 1998 6:04
> Onderwerp: 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
> >
> >
|