Forecast vs. Actual Analysis

[pgdavis2]

Trying to get some stats on the forecast accuracy of intra-day stock prices.

Each stock has a forecast and actual price recorded at each hour of the day.

I want to know the following:

1. How many days was the daily forecast error positive? Tried this:

=count(if(avg(Fcst_Price)-avg(Actual_Price)>0,avg(Fcst_Price)-avg(Actual_Price)) ???

2. How many times in the selected timeframe did the trend last for more than X days? (x being an input variable)

This seems pretty complicated. Has anyone done any analysis like this that can help get me started?

[pgdavis2]

Here's the csv