Are you trying to show a moving price from two weeks ago or one static point with the last available price? I feel like those are two different things.
In reality what i'm trying to do is show a moving price from two weeks ago and from yesterday, excluding weekends. I just asked for the price two weeks ago because I thought that if I was able to solve the two week price I would be able to solve also yesterday's price.
Do you have any ideas??