Get some price history and skip the external api, and have a from job that adds yesterday's price. Much simpler. Been there, done that.