I'm making an excel to keep updating my current portfolio with the latest rates. For this I'm using web-query in excel to pull the LTP of the stock in the portfolio.
Now, I'm able to pull the necessary data properly in the required cell. But the problem is that the cell below becomes blank and I'm not able to add/assign a new web-query to it. Because of this I'm not able to get the required data in that cell.
Can someone please tell me what am I doing wrong in doing so? Also, what is the solution for the same?
My second query is that I want the web-query to automatically change and fetch corresponding data (LTP) depending on the script I change in the script list. I dont want to do it manually when I add, delete or replace anything in the list. As I dont know VBA, so it would be preferred if this can be done using some formula or technique, which I think would surely be there.
Though I'm new here, after going through the forum, it has inspired me a lot and will work towards posting some useful excels in the future. I would very much like to keep sharing my work and keep getting opinion on the same from you all seniors here.
Thanks and regards,
KCUBES.
Now, I'm able to pull the necessary data properly in the required cell. But the problem is that the cell below becomes blank and I'm not able to add/assign a new web-query to it. Because of this I'm not able to get the required data in that cell.
Can someone please tell me what am I doing wrong in doing so? Also, what is the solution for the same?
My second query is that I want the web-query to automatically change and fetch corresponding data (LTP) depending on the script I change in the script list. I dont want to do it manually when I add, delete or replace anything in the list. As I dont know VBA, so it would be preferred if this can be done using some formula or technique, which I think would surely be there.
Though I'm new here, after going through the forum, it has inspired me a lot and will work towards posting some useful excels in the future. I would very much like to keep sharing my work and keep getting opinion on the same from you all seniors here.
Thanks and regards,
KCUBES.