Search results

  1. K

    Import from Y A H O O into Excel using Web-query!

    @ chachi, Working like a charm. Thanks for the useful utility. Regards, kcubes.
  2. K

    Import from Y A H O O into Excel using Web-query!

    @ chachi, Mr MK Singh is right, even I'm getting exactly the same error. I'm using Excel 2007 and Windows XP SP3. Regards, kcubes.
  3. K

    Import from Y A H O O into Excel using Web-query!

    @ chachi The first trick is not working, but the second trick is working just fine and is giving desired results. Now the only problem lies is that I want to modify the web query automatically based on the changes that I make in the column where I'm writing the script names. Without...
  4. K

    Import from Y A H O O into Excel using Web-query!

    If it is not possible to find a solution via some formula, can anyone write a VBA code for the same and attach as a text file here and explain how can I apply the same to to my excel to get the desired result. Regards, kcubes.
  5. K

    Stamp duty on NSE?

    For this you can refer the following link for stamp duty calculation part: http://www.traderji.com/taxation-matters/23430-calculating-other-charges-apart-brokerage.html#post204415 Regards, kcubes.
  6. K

    Calculating Other Charges (Apart from brokerage)

    The Taxes file that I've attached is correct (specially Reliance Money tab) and I've been verifying the same by comparing it with my contract notes that I receive from Reliance Money for the last one and half year. So rest assured that the data provided is true and safe to use for daily...
  7. K

    Miscellaneous Charges.

    @ sangfroid22 For the brokerage part you will have to check out with your broker. For other taxes involved in trading or investing check out the following link: http://www.traderji.com/taxation-matters/23430-calculating-other-charges-apart-brokerage.html#post204415 For the tax...
  8. K

    Calculating Other Charges (Apart from brokerage)

    Apart from brokerage other taxes are as in the file attached. In the file 'Taxes', Reliance Money tab was made by me after understanding the same on the phone through the helpdesk people. It has given me exact calculations which I've matched with the contract notes that they have sent. Most...
  9. K

    Import from Y A H O O into Excel using Web-query!

    @chachi As I mentioned earlier, I dont understand VBA. Also, when I use the refresh button it gives me error 'Compile error in hidden module: Macros'. Moreover I would like to use this in the Excel which I'm making and will not be able to use the VBA thing without knowledge for the same...
  10. K

    Import from Y A H O O into Excel using Web-query!

    @ chachi Firstly thanks for such quick reply. I downloaded the file and tried to figure out what changes was done but was unable to understand how it was done. Except for naming the cells with the query itself. But I did not understand how other connections were added. Also when refresh all...
  11. K

    Import from Y A H O O into Excel using Web-query!

    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...