Hi all am wanting to do some math to generate times an opportunity has been in each state, fo this we have opportunity field tracking enabled and tracked.

now what I have been asked to develop is a system which now read the field history and back fill custom fields in the main opportunity for how long the opportunity is in each stage.

now I can generate a report on the reports engine for this table but am not able to see the object. anybody know how to access this information via apex ?

the fields am after from the table are

edit date

old value

new value

field event

stage duration

parent ID

ordered by edit date if possible.

so that I can get them into an array so that I can itterate though them to populate fields with the time at each stage.