javivi wrote:No, once I have a file with every balance by date, I will crosse (by date) the file against another file who has the currency conversion for every day.
If you already have a file with date and currency values you do NOT have to repeat the account file for the date. It is easier to PUSH down the values for missing dates after the match on the date between the 2 files. Show me the layout and RECFM of
1. Account file
2. Currency file which has the dates and the equivalent currency value for that date.
3. What is the format and Length of Amount field and Date field in the account file?
4. What is the position of date field and currency value in the currency file?
5. What do you need to do finally? AVG? TOT? MIN ? ...
Explain in detail and I will show you a way to do it