Re: update by email

[ Q4-Q1 00 Archive ] [ Current Message Board ] [ Archives ] [ Search ]

In Reply to: Re: update by email posted by Mark on October 18, 1999 at 08:55:00:

: : : : : : : : hi mark
: : : : : : : :
: : : : : : : : i wonder if you could tell me how can i update my investments the "generic way" with an email that comes to me from the greek stock exchange i tried but i havent succed and finally got pretty confused the description of how the stock information comes is the folowing (the correct way to read it is without the word wrap) (b/s stands for buyers, sellers)

: : : : : : : : SYMBOL DATE CLOSE B/S VOLUME HIGH LOW VALUE TRANS OPEN
: : : : : : : : AAAK 13/10/99 21400 . 1575 22500 21100 33534250 18 21115
: : : : : : : : AAAP 13/10/99 15725 . 230 17340 15725 3748075 5 17340
: : : : : : : : ACTIV 13/10/99 8900 B 50170 9400 8820 462535500 541 9400
: : : : : : : : AEGEK 13/10/99 7315 B 180080 7955 7315 1363026300 815 7950
: : : : : : : : AEGEP 13/10/99 6500 S 40280 6870 6500 272671450 148 6840
: : : : : : : : AFAIN 13/10/99 28480 S 81400 28585 24405 2227242450 241 26500

: : : : : : : : please post for me how i must put the KEYS and the VARIABLES for a correct syntax

: : : : : : : : thanks in advance

: : : : : : : Hi John,
: : : : : : : You can import this with the generic price import command:

: : : : : : : "File/Import/Prices/Generic...".

: : : : : : : You would use the format string of:

: : : : : : : SYMB DD/MM/YY NAV XX VV HH LL XX

: : : : : : : and you would not "specify" either of the date/symbol, as they
: : : : : : : are already in the format string.

: : : : : : : Just curious, how do you get this data e-mailed to you? Maybe
: : : : : : : others could benefit from this service.

: : : : : : : Thanks,
: : : : : : : Mark
: : : : : : : --
: : : : : : : Mark Beiley
: : : : : : :
: : : : : : : Fund Manager for Windows 3.1x/95/98/NT
: : : : : : :
: : : : : : :

: : : : : : Hi Mark and John,
: : : : : : I get this email from the Atens Stock Exchange evryday aswell. The service is free, provided you have been registered. However, the procedure to import this data in FM, in an easy and efficient way is not quite so simple and easy I could say. A lot of work and modification has to be done before the importation and the results are not always those you expect.
: : : : : : Mark, perhaps you can help us with an automation, otherwise the data are of a little use for FM users.
: : : : : : Thanks very much and best regards to both of you.
: : : : : : CM

: : : : : Hi CM,
: : : : : It appears as though the file displayed above will import with
: : : : : any modifications using the generic import command? What problems
: : : : : have you run into? If you have a sample file that displays this
: : : : : problem please post it, so we can discuss a solution.

: : : : : Thanks,
: : : : : Mark
: : : : : --
: : : : : Mark Beiley
: : : : :
: : : : : Fund Manager for Windows 3.1x/95/98/NT
: : : : :
: : : : :

: : : :
: : : : Hi Mark,
: : : : I tried to apply the format you suggested but i always get the message that the specified input format did not match any lines in the imported file
: : : : Any hints please?
: : : : Harry

: : :
: : : Hi Harry,
: : : For the format shown above, the format string is correct. I have seen
: : : others report a different format for prices from the Greek exchange, which
: : : is as follows:

: : : Here is one of your lines, for reference:
: : : "Tria Alfa" (CR) AAAK 11/10/99 24800 S 2875 24950 22820 67349250 24 22840

: : : Use the format string:
: : :
: : : XX) SYMB DD/MM/YY NAV XX VV HH LL
: : :
: : : and you do not need to "specify" either the date or symbol.
: : :
: : : Could your file really look like this format?

: : : Thanks,
: : : Mark
: : : --
: : : Mark Beiley
: : :
: : : Fund Manager for Windows 3.1x/95/98/NT
: : :
: : :

: : Hello Mark,
: : I have finally managed to import the ase file emailed to me every evening. I tried the string you suggested and it looks to work perfectly allright.
: : However, i have not checked it thoroughly, because i must firstly to open some 350 new investment files, (this is approximately the total number of shares listed in ASE)and then to start importing the file completely. This is a tedious task and i hope that in a future enhancement you may find a solution for such cases.
: : Thank you very much for the help and as soon as i complete the work , I will keep you informed.
: : Best regrads
: : Harry

: Hi Harry,
: Do you mean "open" 350 investments, or create them ("New")? If you are
: just opening 350 investments you can use a portfolio to open all of them
: for you.

: Thanks,
: Mark
: --
: Mark Beiley
:
: Fund Manager for Windows 3.1x/95/98/NT
:
:

Hi Mark,
Allas!!! I mean to create 350 investments
Thanks
Harry

Replies: