C
cwalrus
I am creating a database to track stock option activity. I wanted to have a
table for all (grant, vest, exercise) stock option transactions (similar to
the inventory transactions table in the Inventory Management template),
however, I would like to automate the stock option vesting so that when now()
is equal to the vesting date, the table will be populated with the number of
options that vest in a '#OptionsVested' field.
I would like the table to have the following fields:
Date, Employee, TransactionDesc, #OptionsGranted, #OptionsVested,
#OptionsExercised.
Another table would contain the vesting information including the date and
number of options vesting on each date.
In other words, I'd like to rework the Inventory Transactions table so that
Product ID is Employee, Units Ordered is Options Granted, Units Received is
Options Vested, and UnitsSold is Options Exercised, but I'd like Units
Received to populate automatically based on today's date.
This is harder than I thought it would be to explain. Let me know if it's
unclear.
table for all (grant, vest, exercise) stock option transactions (similar to
the inventory transactions table in the Inventory Management template),
however, I would like to automate the stock option vesting so that when now()
is equal to the vesting date, the table will be populated with the number of
options that vest in a '#OptionsVested' field.
I would like the table to have the following fields:
Date, Employee, TransactionDesc, #OptionsGranted, #OptionsVested,
#OptionsExercised.
Another table would contain the vesting information including the date and
number of options vesting on each date.
In other words, I'd like to rework the Inventory Transactions table so that
Product ID is Employee, Units Ordered is Options Granted, Units Received is
Options Vested, and UnitsSold is Options Exercised, but I'd like Units
Received to populate automatically based on today's date.
This is harder than I thought it would be to explain. Let me know if it's
unclear.