You've posted to the FM GO portion of this forum. Does that mean that you are doing this on an iOS device?
Assuming that your imported data includes a unique identifier, you can use that field in a find or relationship to access only records for that stock and the resulting set of records can be sorted by a transaction date to put them in chronological order. From there, the GetNthRecord function can be set up to access the value from the preceding record so that you can compute the difference. But this works best for small numbers of records in your found set or portal--especially if you are using FileMaker Go. On the other hand a self join relationship matching by Stock Symbol and sorted by Date could be constructed so that you can use the relationship to access the values in the preceding transaction record for that stock.
Thank you for the help. Sounds like it will work for me. Will do it later today.
I am using FileMaker Pro 12 on a Mac. I do not have anything special other then the MAC. Not sure what forum I should have posted to.
Thank you very much for your help.
If you look at the top of this screen, you will see a number of "file tabs" each for a specific area of the forum. Report an Issue is for filing reports of possible bugs in the software. FM Pro Forum is for getting help in how to use FileMaker Pro, and so forth...