**Executive Summary**
I require the development of a excel spread sheet that can collate data from a real time streaming trade feed. Examples of the data that needs to be collated are number of updates, number of executed trades, price of executed trade etc
The feed is a real time feed and only has a limited number of “tags?? contained within it, such as, time, price, bid, offer etc. It doesn’t carry any historical information so there is a need to collate information in real time. The data is to be captured over a predetermined time period (between 10sec and 2 minutes) and then analyzed.
The data feed is an IQFeed and is internet based. It has a small management tool that controls the data feed that will need to be installed.
The excel plug-in that will import the data from the feed into excel is Quotelink QL-0.77.94. (or later) This will need to be uploaded.
The data from the trade feed must be translated and captured in excel as the algorithms that are being used to analyze the data have been in written using standard excel functions and formulas.
**Technology Provided**
IQFeed 4.5.0.3 ??" Usernames and password will be provided as required
<[login to view URL]>
Quotelink QL- 0.77.94 ??" Usernames and passwords will be provided as required
<[login to view URL]>
Gmail Account ??" Email account details and passwords will be provided as required
## Deliverables