Pulling Daily Price Data from MT4 to Excel

Hi,

I need to pull daily price data from MT4 to excel for 300days data points. Only "close" price is needed.

When i open my excel template everyday, the price data will be automatically updated.

I want it in the way whereby the data set only contains of 300days.

When a new daily price data point is updated, the oldest daily price data point would be eliminated so that it only contains 300days data points in one currency pair.

This is to be done for 73 currency pairs.

Thank you.