Assuming it is, in fact, a coding issue, and without knowing anything about the code, then I guess one possibility is:
The first thing that comes to my mind is that the code is populating Excel one cell at a time, rather than all at once. The overhead could possibly be multiplied by the number of individual cells being written to, in this case.
The interaction between Excel, SQL, and C#, is not my thing; but if these guesses/assumptions are correct, then it certainly may be a coding issue. (Probably easier [and less expensive] in this case, to code one cell at a time vs coding an all at once transfer)
I'm curious to know what the original coders say about it.
Again, this is not my area, but using Excel probably greatly sped up development. But it may actually be fast enough if the above bottleneck (assuming it applies) is addressed. Just my guess.
Another option is to have C# do whatever you're doing with the excel data while trading. Have C# output the conclusions you would have drawn via the Excel sheet ... GO or NO-GO ... BUY, HOLD, or SELL ... ETC.
The app could still give you your original excel output if and when desired (after the trading session, for example) for your research purposes.
The first thing that comes to my mind is that the code is populating Excel one cell at a time, rather than all at once. The overhead could possibly be multiplied by the number of individual cells being written to, in this case.
The interaction between Excel, SQL, and C#, is not my thing; but if these guesses/assumptions are correct, then it certainly may be a coding issue. (Probably easier [and less expensive] in this case, to code one cell at a time vs coding an all at once transfer)
I'm curious to know what the original coders say about it.
Again, this is not my area, but using Excel probably greatly sped up development. But it may actually be fast enough if the above bottleneck (assuming it applies) is addressed. Just my guess.
Another option is to have C# do whatever you're doing with the excel data while trading. Have C# output the conclusions you would have drawn via the Excel sheet ... GO or NO-GO ... BUY, HOLD, or SELL ... ETC.
The app could still give you your original excel output if and when desired (after the trading session, for example) for your research purposes.
