Hi eveyone,
My question seems to be unique, so far I have failed to find a solution.
I call a function from an Excel sheet which gets live data from a stock server. My Function parameters are bid, ask, number of shares sold, number of shares bought, and several other relevant data. The thing here is that, for a function to run, just a single change in any of these parameters is sufficient. However, I need to make sure that, before my function runs, all relevant data to be updated first for each transaction. Therefore, the function does not work as I expect it to do. For verification purposes I am trying to count no of shares bought and sold in a day but my function misses up to 40 % of transactions. It must have been called eventhough not all the parameters are updated for a complete transaction and hence results in erroneous output.
Is there anyone who faced the same problem and, more importantly, has a solution? The Excel sheet is updated from the server dozens of times a second for several stocks. Eventhough I try it with just one share, the failure ratio is as much as 40%.
Many thanks in advance.
My question seems to be unique, so far I have failed to find a solution.
I call a function from an Excel sheet which gets live data from a stock server. My Function parameters are bid, ask, number of shares sold, number of shares bought, and several other relevant data. The thing here is that, for a function to run, just a single change in any of these parameters is sufficient. However, I need to make sure that, before my function runs, all relevant data to be updated first for each transaction. Therefore, the function does not work as I expect it to do. For verification purposes I am trying to count no of shares bought and sold in a day but my function misses up to 40 % of transactions. It must have been called eventhough not all the parameters are updated for a complete transaction and hence results in erroneous output.
Is there anyone who faced the same problem and, more importantly, has a solution? The Excel sheet is updated from the server dozens of times a second for several stocks. Eventhough I try it with just one share, the failure ratio is as much as 40%.
Many thanks in advance.
