|
| Discuss My Excel Profit_Loss Traking Utility at the Software within the Traderji.com - Discussion forum for Stocks Commodities & Forex; Hello All, Whether u r day trading or doing delivery based trading--knowledge of the ... |
|
|||||||
| Notices |
| Software Charting, trading & technical analysis software, trading system development and backtesting. |
 |
|
|
Thread Tools |
| Sponsored Links |
|
#1
3rd September 2005, 09:02 PM
|
|||
|
|||
My Excel Profit_Loss Traking Utility
Hello All,
Whether u r day trading or doing delivery based trading--knowledge of the risk u can really take is of utmost importance----Moreover during day trading---when a script starts falling---the risk aspect(the Loss--along with the consideration of the brokerage and other taxes) plays a crucial role----Many a times we tend to calculate Profit/Loss approximately with out the least considerations of the brokerage and other miscellaneous costs---Moreover instead of relaying on the Data provided by broking houses ---one should manualy maintain the porfolio details too--- For both this purposes--this is a small excel utility(entirely made by me--which will be part of of a bigger software later)--- I would like to put forward here in this forum---where from I have benefitted immensely---This is still now professionally sold by me at a nominal cost----- Dearest Traderji---The zipped Excel file----occupies around 900 kb---If u kindly let me know---how I can upload it here---I will be obliged--- Regards, joy_mitali 
|
|
#4
3rd September 2005, 11:42 PM
|
|||
|
|||
|
Re: My Excel Profit_Loss Traking Utility
Quote:
Why dont you use the savefile.com site to uplaod your file. http://www.savefile.com/ regards karthik
|
|
#6
4th September 2005, 04:53 PM
|
|||
|
|||
|
Re: My Excel Profit_Loss Traking Utility
Hi SSM,
If u consider the data from Aug to 2nd Sept---BOI started falling from 143 level to a low of 114.8 leve(on 24th AUG) after which it has stared increasng to 122 level---I think as the market itself is quite high there can be a correction any moment---where by it may fall to 112 level---U can cover up ur short there----On the upside BOI can go to 135 level----Keep a Stop loss of 126---130-----dependind on ur risk apetite---- Bharti tele is in already in a high side pricing range---this stk can move to 335--340 level on upside and 300 on dwn side(has a greater probablity)----Remain in the long position with a stop loss of 315---310---depending on ur risk ability---But my opinion---do not take too much chance on upside----sell it around 330-----unless u feel the market too bulluish--- Regards, joy_mitali
|
|
#8
5th September 2005, 09:44 PM
|
|||
|
|||
|
Re: My Excel Profit_Loss Traking Utility
Hi Friends--
As suggested by Karthikmarrar---I m uploading the file---www.savefile.com--- The link is---- http://www.savefile.com/projects/898411 Some datas r included in the file ----u just try to see---if u can understand it--- I will explain--the file ---next time-- One more imp think---Plz ---never ever remove the split----otherwise---u wont be again to create the split as the file is ---password protected--- Do give ur suggestions----for further improvement--- Regards, joy_mitali
|
|
#9
6th September 2005, 03:43 PM
|
|||
|
|||
|
Re: My Excel Profit_Loss Traking Utility
Hi All---
As per as I said---I m explaining the terms in my excel file--- Column A---Client type---U can put J(actually J for Joy) or ADM(administrator)--Acutally my original version has diff client types---for whom there r diff brok. structures---If someone wants to tailor-make it ---do mail me at --jayanta.bebo@**********--- Col B---Brok.House----it can be SK(ShareKhan),IB(Indiabuls),ICICI---If u put J--(in col 1)---then there r diff brok. structures for diff . Brok.houses---If others want to include some more brok. houses,(with more diff brokerages for intraday and delivery)---then put the suggestions here---- Col C---self explanatory Col D----Stk. Ex.--only Indian Stock Exchanges has been includd---For international exchanges---and the brokerages---I will like to have more information---Knowledgables---Plz provide it---I will try to incorporate them--- Col--E---self explanatory-- Col F---Buy Typ.--I--for intraday trading---D---for delivery based---For both these diff values---the brokerages gets changed differently---- Col--G----Put the value at which u r buying the stock--- Col H---How many u r buying--- Col I---Prob. Investment---If u put the value in Col H--then value in col I should not be present----this col is to get idea of bow many stks u can buy for for ur choisable investment---- Col K---The CMP--is to see to see how much deviatiation(%)--is occuring from buy priceCan be seen in Col J------(it is optional)---- Col O ---for SP(actual) which will give u--the profit and loss--- Col P---only if Col A--is ADM---- Regards, joy_mitali
|
|
#10
7th September 2005, 03:03 PM
|
|||
|
|||
|
Re: My Excel Profit_Loss Traking Utility
I went to http://www.savefile.com/projects.php?pid=898411 but couldn't get a DOWNLOAD LINK.... A smiley ad overlays the download bar. Apart from this, the download button has no link to anywhere...
Its not downloadable! Please help! Thanks in advance.
|
| Sponsored Links |
|
|
|
| Bookmarks |
| Thread Tools | |
|
|
Similar Threads for: My Excel Profit_Loss Traking Utility
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| MY Excel stock tracker | amitkr | Software | 145 | 24th June 2008 03:03 PM |
| Need BSE Stock Price List in Electronic form (Excel, CSV format) | gharesh | Equities | 5 | 20th June 2008 07:55 PM |
| Portfolio Management & Tracking through MS Excel | nkpanjiyar | Software | 23 | 12th April 2008 10:24 PM |
| excel to metastock | veneet | Software | 3 | 21st February 2008 02:29 PM |
Indemnity, Disclaimer & Disclosure
Notice:
• By visiting Traderji.com you indicate your acceptance of our Forum
Rules Disclaimer & Disclosure and indemnify Traderji.com, its
associates and related parties of all claims howsoever resulting from
the usage of the forum.
• Disclaimer: Trading or investing in stocks & commodities
is a high risk activity. Any action you choose to take in the markets
is totally your own responsibility. Traderji.com will not be liable for
any, direct or indirect, consequential or incidental damages or loss
arising out of the use of this information.
• Disclosure: The information in this forum is neither an offer to sell nor solicitation to buy any of the securities mentioned herein.
The writers may or may not be trading in the securities mentioned.
• All names or products mentioned are trademarks or registered trademarks of their respective owners.
General Content Disclaimer Notice:
In light of our policy of encouraging candid, open exchanges of views and the rapid distribution of information originating from many sources, Traderji.com cannot determine the accuracy of information that may be uploaded to the forum. Opinions, advice and all other information expressed by participants in discussions are those of the author. You rely on such information at your own risk. You are urged to seek professional advice for specific, individual situations and not rely solely on advice or opinions given in the discussions. Since Traderji.com is an open and free discussion forum, any comments made by members of this forum in their posts reflect their own views and not of the owner or administrator of Traderji.com. Thus the owner/administrator indemnify themselves of all claims whatsoever and will not be liable or responsible for any members comments/views in this forum Traderji.com. If you find any objectionable or offensive posts made by members of this forum which you would like to bring to our notice for removal then please Contact Us.
