Hi there,

I'm somewhat new here - but I'm keen to learn. I'm hoping someone can point me in the right direction to undertake the following analysis in an automated fashion.

I have a list of dates/times for Economic news events that have taken place previously. I would like to be able to determine and output the following:

For a currency pair (i.e EURUSD):

Derive Max/Min Price within a 5 minute period prior to the release, return the time and price (time can be within ideally a 10 second granularity, minute is OK)

Derive Price at the time of news release

Device Max/Min Price within a x minute period prior to the release, return the time and price (time can be within ideally a 10 second granularity, minute is OK)

Ideally I want the ability to capture this information across multiple currency pairs to derive and understand movement.

I'm happy to be pointed to a freelance company that could do this work for me should this be required.

Paul