471,355 Members | 1,671 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,355 software developers and data experts.

Calculate FIFO valuation using ACCESS

I am trying to calculate the year end cost basis of equities held. I have downloaded all the transactions (purchases and sales) for the year and have them in a table. I need to calculate the value of each equity at year end using a First in First Out method. Does anyone have experience with this and any advice as to how to begin?
Apr 5 '07 #1
3 5880
Rabbit
12,516 Expert Mod 8TB
Why does it have to be FIFO?
Apr 5 '07 #2
Why does it have to be FIFO?
Trying to tie out to year end broker statements the gains/losses, year end cost etc. & that is the method they use.
Apr 6 '07 #3
Rabbit
12,516 Expert Mod 8TB
Trying to tie out to year end broker statements the gains/losses, year end cost etc. & that is the method they use.
It seems to me that if its just simple addition and subtraction of gains and losses then there's no need for FIFO.

Is the table already sorted by First In? And if not I assume there's a date/time field so that you can actually determine First In?
Apr 6 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by meyvn77 | last post: by
3 posts views Thread by bill mahoney | last post: by
6 posts views Thread by Serious_Practitioner | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.