Dear Profit taker,
I would like to share a small suggestion on this excel file. It looks like currently if we want to view the option chain for another stock, we have to go to Data--connection-Edit query etc. Instead of that, why dont you simply add a new sheet in the same excel file with all the F&O symbols and expiry dates and you can just add these cells as reference in the data query link.
I have never done anything in the method like you have done with Data-->Connections.
In excel macro when we download anything like that we can refer the cells for he variables. I believe there should be something you can workout for your excel file as well. it well help a lot
I would like to share a small suggestion on this excel file. It looks like currently if we want to view the option chain for another stock, we have to go to Data--connection-Edit query etc. Instead of that, why dont you simply add a new sheet in the same excel file with all the F&O symbols and expiry dates and you can just add these cells as reference in the data query link.
I have never done anything in the method like you have done with Data-->Connections.
In excel macro when we download anything like that we can refer the cells for he variables. I believe there should be something you can workout for your excel file as well. it well help a lot
Dear Amit Sir,
I think you may changed Link in Edit Web Query window.
Try do this:
Step 1 : Go to Data (in Excel) --> Connection ---> Select STOCK FUTURE -->
Properties --> Select Defination Tab ---> Click Edit Query --> Just Change Stock name from RELIANCE to INFY in Address Bar and click Go --> Click Import --> Click ok --> Click Close.
Step 2 : Go to Data (in Excel) --> Connection ---> Select STOCK OPTION -->
Properties --> Select Defination Tab ---> Click Edit Query --> Just Change Stock name from RELIANCE to INFY in Address Bar and click Go --> Click Import --> Click ok --> Click Close.
I think you may changed Link in Edit Web Query window.
Try do this:
Step 1 : Go to Data (in Excel) --> Connection ---> Select STOCK FUTURE -->
Properties --> Select Defination Tab ---> Click Edit Query --> Just Change Stock name from RELIANCE to INFY in Address Bar and click Go --> Click Import --> Click ok --> Click Close.
Step 2 : Go to Data (in Excel) --> Connection ---> Select STOCK OPTION -->
Properties --> Select Defination Tab ---> Click Edit Query --> Just Change Stock name from RELIANCE to INFY in Address Bar and click Go --> Click Import --> Click ok --> Click Close.