I am relatively new to Filemaker and use it for some recording of equities (shares) – especially if they are not listed on major stock exchanges .
I have price file for the unlisted equities where I have recorded the closing price. My Filemaker 'price file' is a simple one:
A table showing each ticker (in the header) and its price & date (sorted) in columns, however to find the Highest & Lowest price recorded in the last 12 months needs a manual search.
Is there a simple way to have the 12-month Highest & Lowest values displayed on the layout without conducting a search on each ticker?
I thought of having a script run when the layout is entered, however depending on the volume of data being processed, the response time suffers. Can anyone help with a custom function please, I cant seem to adapt Brian Dunning’s Min Value (1st;Value) function easily without using it on all dates rather than just the last 12 months. - I don’t fully understand the approach.
I then have to copy & paste my results into another table in Filemaker.