Would any of you be interested in such a utility? If so, please let me know - I am planning to write it to download data from Sharekhan, since I have an account there, but if you need one of a different account, say ICICI Direct or such, please let me know.
I may charge fees for the utility but to the first set of people who answer (and help me beta test!) I will provide it for free.
Related posts:
- Capital Gains Tax: A primer If you make a profit buying and selling Capital Assets...
- The Real Estate Cash Flow Calculator If you've read Robert Kiyosaki's "Rich Dad, Poor Dad" series...
- The new tax return form The Government has introduced a new tax return form, called...
>Hey .. thats a cool idea … I ll be interested!!!
11.24.06 at 10:40 AM
>Ya, sure, i can do the beta test for you
11.24.06 at 11:05 AM
>Yes I would be interested for ICICIDirect.
Thanks,
apple123_4567 AT THE RATE Yahoo D0t com
11.24.06 at 1:54 PM
>Deepak,
Great idea. I’m interested – i use ICICI Direct
11.24.06 at 2:24 PM
>Yes, I am also interested to use for ICICIdirect. If you want some development help, pls let me know.
11.25.06 at 11:02 AM
>Hi,
Am interested too.
Wonder what language u use?
I usually download the data from ICICI Direct onto excel and do the calculations using excel.
Regards
Prem
11.25.06 at 1:43 PM
>Wow, cool response. I have figured out how things work at Sharekhan, though I have no access to ICICIDirect’s data. I personally have a complex excel sheet I use for tax calculation. If ICICIDirect provides data that is exportable to excel that’s a big boon!
If someone can help me with some dummy ICICI data (say provide me with a web page or HTML file with the following: Scrip, buy or sell, price, brokerage, other charges, STT (needed for capital gains) and totals. I can then figure out how to parse and use it properly…
I will be back soon with more info.
11.26.06 at 11:38 AM
>I am interested. I have an account with ICICIDIRECT and Motilal Oswal
12.06.06 at 2:49 PM
>I have already developed a utility to process ICICI direct data and i am using to calculate my own share profit and tax. This utility is built using oracle pl/sql, you just need to copy the trade book data and paste into a text file and provide the input to the utility. It could have been developed in excel too, but developing in pl/sql helped me to easily validate intermediate steps in processing and generate reports on profit/tax by financial year etc. It specifically helped me because i had more than 500 transactions in the last year and for every (x) shares sold, i had to find the exact set of shares bought on what date and at what price. For example, if I bought 50 shares @2000 on 10-JAN-2006, 300 shares bought @2500 on 15-JUN-2006 and sold 200 @3000 on 20-AUG-2006, I have to process this as 50 sold @3000 against 50 bought @2000 and 150 sold @3000 against 150 bought @2500.I haven’t yet developed a web interface to use this online, but i can help if anybody provides text file to me.
Anji
01.29.07 at 1:43 AM
>I have written such utility for ICICIdirect. Its needs some manipulation. You can send me sample (fake) data file to test my output
My email: yogeshkulkarni@yahoo.com
05.17.07 at 9:00 AM
>I need it. could you please send it at agrawalamit@rediffmail.com
07.21.08 at 4:54 AM
>hi if any body have such utility plz send it on my mail
08.13.08 at 5:16 PM
>I have developed stand alone utility to calculate short term/long term profit by year wise. Input will be Excel file with a records in the following format
StockName TransactionDate Transcation Type(Buy/Sell) Quantity Price
Output will be an Excel file with summarised balance report sheet and yearwise split of short/long term in alphabetical order.
Ofcourse, I will charge for application.
If anyone interested contct me
contact. sym.coder@gmail.com
08.17.08 at 3:34 PM
>hi,
Any head way on the cap gain calculator utility, especially in 2008 (new taxes and excemptions etc incorporated)
if you can tell me how do i try and/or buy it off you
WOULD BE GREATFUL IF YOU CAN REVERT ON MY EMAIL
regards
sailaab at gmail com
09.18.08 at 9:37 AM
>If you wish to calculate capital gains for sharekhan, kindly send me the transaction statement from them, and i can calculate it and send the tax figures for you?
pls send your statement at
capitalgain_calc@rediffmail.com
09.20.08 at 11:03 AM
>I have added GUI tool for calculating capital gains for stocks & MF's.
see the work at
http://excelcapitalgains.blogspot.com/
10.05.08 at 6:29 PM
>I am interested to have this utility for ICICIDirect.com and Relaince Money.
Can anyone help. I late to file Income Tax Returns for FY 2007-08.
Sanjay Agarwal
snjy_1@yahoo.com
03.24.09 at 5:29 AM
>Did you comeplet the work? I am interested.
11.11.09 at 9:26 AM
>I need it for icici direct. I am reachable thru saimagesh@gmail.com
Thanks,
Sai
12.17.09 at 9:35 AM
>i need it for icici direct. I have used http://excelcapitalgains.blogspot.com/ and ran for some of my scripts but the numbers differ. I do understand that it is a demo version but still i dont understand why the profit amount vary? Also the email id that is mentioned doesnt work.It keep bouncing back. Anyone can help me in calculating my capital gains for icici direct would be really helpful.Please email me at sree2k7@yahoo.com
12.27.09 at 10:49 PM
>try http://www.perfios.com
02.12.10 at 7:49 AM
>Have you gotten around with working on the Sharekhan utility? Seems like the original poster was from couple of years ago. Is it still on? I am interested.
03.12.10 at 7:35 PM
>Any update on this one for sharekhan?
03.12.10 at 7:45 PM
>I am also looking for some utility to extract my details from sharekhan and calculate capital gains. If you still have it, can you please share it with me at ashishgupta1977@rediffmail.com
05.06.10 at 3:55 PM
Please let me also have a sheet in this regard. I will be thankful to use. I use ICICI direct.
03.03.12 at 10:54 AM