Discussion Locked

automatic updation of excel site from share market

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I HAVE ONE TERMINAL CALLED ANGEL BROCKING DIET. THIS SITE IS ONLINE TERMINAL FOR SHARE MARKET. I WANT TO UPDATE AUTOMATICALLY IN TO EXCEL SO THAT I CAN USE SELF MADE FORMULA FOR TECHNICAL MEASURES AND ON WHICH I DECIDE TO BUY OR SALE SHARE IMMEDIATELY.ONE THING I LIKE TO CLEAR THAT IN EXCEL I WANT ONLINE UPDATION WITHOUT REFRESHING IT. CAN IT IS POSSIBLE? AND HOW?

1 reply

by salim

I am pretty sure, you can do it by putting =not the real value value but =[one more new excel sheet]![cell number].value, where new excel spreed sheet is your real sheet where you are updating , as far as if it is online, you need to add a code for auto refresh.

This discussion is closed to new replies.