Hello Wa
Im afraid that I can't glean much from your last post because there is just too much unformatted data. This is due to this software being unable to give a tabular
structure because of the text limitations. However, this website will allow you to upload a workbook, so if you create some sample data, I can at least see a proper
column structure and what the cell formulae are referring to.
At the moment, you just need to convey how the data you get is handled, and what decisions are being made from it, so you dont need a lot of data. You could probably
do it with a short history of one stock or commodity or whatever. Once I get my head round this and a few other issues I will be able to advise you better.
Questions:
1. You talk about a data stream update from the broker. Is this a full schedule of prices on another spreadsheet, or do they arrive piecemeal as individual records?
2. Do they "hit" your system automatically, or can you control/collate data before presenting it to your systems?
3. How often do you get updates ?
4 You have an ask price and your sell price. If the ask price goes up, so does the sell price. By the same amount ? By the same %?
5 When the ask price falls, you don't drop your sell price, but you send detail to the broker ? Is that as soon as it falls, or are there other factors ?
Im sorry about all the questions
but I like to get a proper understanding otherwise I dont think I will be able to give the best help.