Get Input From Excel
Get Input From Excel
09 Jul 2014, 09:27
Dear Admin
I am doing some complex calculations in Excel worksheet- based on Stock Prices and Wish to hedge the currency
When my conditions are True , One specific cell changes from "0" to "1" and other cells have trade type( buy / Sell) , Qty , SL etc etc
Is it possible to get data from specific cells of this Excel file (buy(1) / sell (-1) , Qty , SL , Etc) and then execute trades based on that data
Regards
Winn Trade
Replies
WinningTrader
09 Jul 2014, 14:57
Invalid,
The Excel file is a live file - rates change real time - will EPPLUS still support -
@WinningTrader
WinningTrader
09 Jul 2014, 14:58
Invalid,
The Excel file is a live file - rates change real time - will EPPLUS still support -
@WinningTrader
Invalid
09 Jul 2014, 15:07
RE:
What do you mean live file? updated frequently?
You can check the file in OnTimer method in order to see if there's any change in the Excel File. If so - process these changes.
WinningTrader said:
Invalid,
The Excel file is a live file - rates change real time - will EPPLUS still support -
@Invalid
Invalid
09 Jul 2014, 09:50
Hi WinningTrader.
You can use Epplus library to access your data from Excel file. But it should be saved in xlsx format. Here you can find how to read data: http://blog.fryhard.com/archive/2010/10/28/reading-xlsx-files-using-c-and-epplus.aspx
@Invalid