Hi guys,
I have an excel question. So I’m using excel as a bridge between python and my trading platform ninjatrader. I’m getting values from another data source and processing those values in python and then sending those values to a file in excel (file 1). Then, I have another file (file 2) that is pulling the data from from file 1 (vlookups) and then sending it to ninjatrader.
Python cannot write to an excel file that is open. So file 1 has to be closed when python is saving the data to it.
I cannot send data from python directly to ninjatrader.
Problem: python is constantly updating file 1 every 20 minutes without opening the file. File 2 is open and doing vlookups in file1. But because file1 is closed the values don’t update automatically. I can’t have file 1 open bc python can’t write to excel if it’s open.
Is there a way to update my vlookups in file2 without having file1 open... and do this real time? In my data connection I have checked automatically update ... but it doesn’t.
Any ideas? Thanks.
I have an excel question. So I’m using excel as a bridge between python and my trading platform ninjatrader. I’m getting values from another data source and processing those values in python and then sending those values to a file in excel (file 1). Then, I have another file (file 2) that is pulling the data from from file 1 (vlookups) and then sending it to ninjatrader.
Python cannot write to an excel file that is open. So file 1 has to be closed when python is saving the data to it.
I cannot send data from python directly to ninjatrader.
Problem: python is constantly updating file 1 every 20 minutes without opening the file. File 2 is open and doing vlookups in file1. But because file1 is closed the values don’t update automatically. I can’t have file 1 open bc python can’t write to excel if it’s open.
Is there a way to update my vlookups in file2 without having file1 open... and do this real time? In my data connection I have checked automatically update ... but it doesn’t.
Any ideas? Thanks.
