Stocks To Keep A Close Eye On

Status
Not open for further replies.

asnavale

Well-Known Member
Hi Uma...

Can u give me the sheet? Or is it the same sheet u give ur updates on.... i want to put all my stocks and keep a watch on them.... BTW how will they be updated automatically... there should be some connecting software...Ain't it? :-?.... anyways let me know if it is just an excel sheet or something else....

Also Add me to your yahoo messenger...........

Also Thank U for reminding me not to post in the other thread :)

Thanks A Ton....
Hi Chaitanya,

The Excel sheet posted by Uma contains all the required formulas inside. You don't need to program anything. Therefore you can use that sheet itself and replace the existing values with your data. But remember not to do anything in the columns J, K, L, M and N. That is the columns with heading "P/L per share", "Total P/L", "P/L %", "Stoploss Reached?" and "Target Reached?" should not be changed. Don't delete anything in these columns even if they are empty. The Data in these columns will be calculated automatically when you put your data in the other columns. You can change the first two rows which contain the title to suit your needs. Column A to I contain your data.

The sheet at present holds 54 stocks. If you need to add more rows just go to last empty row copy the contents of the cells in column J to N from the row above into the corresponding cells of the last row. This you can repeat for any number of rows as you need.

This is all there for the worksheet. Not at all a difficult job.

-Anant
 

asnavale

Well-Known Member
Re: Advice Needed From the Community

Hello Guys,

Pretty much my first post here and I am already seeking advice :) Would really appreciate it if I can get your opinions about some questions that I have. Please pardon me if this is not the right thread where I should post these questions. Here I go:

I am attaching a snapshot of my current portfolio. I would like your opinion about why all of it is going in red even though the SENSEX is increasing? Also at the same time I am worried about Brawn Pharma and Aimco Pesticides (even from the point of holding on). Any suggestions as to how can I improve my portfolio returns and when can I expect to break even with around 5% growth on it?

PS: Mr. Savantgarde, I have been following your posts on this forum and really admire your viewpoints. I would really appreciate if you can provide me some insight on this matter.

Best Regards,

Dr. Joshi
Hi Dr. Joshi,

The increase in sensex has nothing to do your portfolio value. The sensex reflects the change in the value of some 30 selected shares and not all those which are traded in the exchange. The reason for your portfolio going down is very clear. All those stocks you have purchased are at a higher price and the current price is going down, naturally your portfolio value goes into red. I don't know when and on what basis you purchased those. Unless you are clear about what, when and why you are purchasing you can not expect to make profit. Not only that, before purchasing you should also determine when you want to sell them and come out. It not only a plan of entry but a plan for exit is also equally important. If you don't know how to come out then don't enter. Otherwise you will be caught in the Chakravyuha like Abhimanyu.

What to do now is your choice. May be Savantji can give some rescue plan but for how many people does he go on helping putting in his precious time, effort and energy?

-Anant
 

asnavale

Well-Known Member
please tell me how to get the stock data/ EOD
into amibroker
Hi izzner,

To get data into your software, first get the data needed from a data provider. You can get Bhavcopy from both BSE and NSE free of cost. This Bhavcopy contains data of each and every share traded on the day with Open, High, Low, Close, Volume and some additional data. For your technical analysis the open, high, low, close and volume are important and minimum required. Therefore it is necessary to remove extra data from the Bhavcopy. Some members like Hemen Kapadia in Traderji have some simple free sotware to get the Bavcopy and process it to give only the required data (Look for these under 'Data feeds' thread). The output from these can be used to update your databse.

The data provided is generally in simple text format known also as 'ASCII' or 'CSV' file format. You can feed these files to AmiBroker and update the database.

In AmiBroker, Click on File from menu bar and down in the list you have 'Import wizard'. Clic on it and the wizard window opens. just follow the instructions in the wizard and your data will be updated.

In case you require further help please let me know. I will give more detailed procedure.

Regards

-Anant
 
Re: Advice Needed From the Community

Hi Dr. Joshi,

The increase in sensex has nothing to do your portfolio value. The sensex reflects the change in the value of some 30 selected shares and not all those which are traded in the exchange. The reason for your portfolio going down is very clear. All those stocks you have purchased are at a higher price and the current price is going down, naturally your portfolio value goes into red. I don't know when and on what basis you purchased those. Unless you are clear about what, when and why you are purchasing you can not expect to make profit. Not only that, before purchasing you should also determine when you want to sell them and come out. It not only a plan of entry but a plan for exit is also equally important. If you don't know how to come out then don't enter. Otherwise you will be caught in the Chakravyuha like Abhimanyu.

What to do now is your choice. May be Savantji can give some rescue plan but for how many people does he go on helping putting in his precious time, effort and energy?

-Anant
Hi Anant,

Many thanks for the reply. I surely do understand that SENSEX is just based on the performance of 30 stocks. But in general its the indicator of the current market trend or am I wrong about it? More precisely, what I meant in my query was this:

I bought these stocks with the target of making short-term profits (read growth of around 4-5 % in a week or so). My entry strategy was based on seeing buy signals through MACD (on a 3 month chart) and 20D/5D signal. But somehow I guess I interpreted those signals wrong. I definitely stand corrected.

I would really appreciate thoughts about whether to hold on in the hopes of breaking even (or even making profit) ;) or to sell and cut my losses short? I definitely can wait for another week or two, but that restricts me from trading as I have invested my entire equity in this portfolio.

Once again, thanks a lot for your opinion.

Best,

Joshi
 

SavantGarde

Well-Known Member
Re: Advice Needed From the Community

Dr.Joshi,

Yourself Being A Doctor, I Hope You Will Excuse Me, If You Do Not Find A Sweet Pill In What I Have To Say.

One Reason For Your Portfolio, Could Possibly Be That You Are Scanning For 52 Week High & Low.....

Except For RPL, UNITECH, SUZLON, Your Portfolio Will Need To Be Exorcised Of Others.
RANBAXY, You May Exit Between 340-385, Whenever You See The The Price.

While Others You May Exit With A Little Profit Before December 3rd Week.

Now Coming To Investing Strategy, Entries Should Always Be Based On Technical Analysis & For Longer Term Holding Fundamentals Must Support Or Justify Your Holding Scrips Beyond A Certain Duration.

For Me Personally, I Don't See Any Wisdom When People Talk Of Long Term Investment, It May Have Had Importance In The Past, But No Longer, Ever Since We Are Globally Connected, My Diktat Is Simple, BUY When It Triggers BUY & SELL When It Triggers SELL, Whether This Happens Once, Twice Or More Times In A 12 Month Period.

Always, Invest In Good Companies, With Clean Records.

It Is Becoming Increasingly Difficult For Me To Look Into Individual Portfolios, I Suggest, If You Have An Inclination & Time, To Read Up On Investment Strategies & Other Related Subjects, Including Basic Techncal Analysis.

All Points Raised By Anant In His Reply To You Are Extremely Important As Well.


Happy & Safer Investing

SavantGarde

Hello Guys,

Pretty much my first post here and I am already seeking advice :) Would really appreciate it if I can get your opinions about some questions that I have. Please pardon me if this is not the right thread where I should post these questions. Here I go:

I am attaching a snapshot of my current portfolio. I would like your opinion about why all of it is going in red even though the SENSEX is increasing? Also at the same time I am worried about Brawn Pharma and Aimco Pesticides (even from the point of holding on). Any suggestions as to how can I improve my portfolio returns and when can I expect to break even with around 5% growth on it?

PS: Mr. Savantgarde, I have been following your posts on this forum and really admire your viewpoints. I would really appreciate if you can provide me some insight on this matter.

Best Regards,

Dr. Joshi
 

SavantGarde

Well-Known Member
Dr.Joshi,

In View Of Not Having Seen Your Reply To Anant, I Gess Many Things I Have Written Is Redundant, Please Disregard Those That Don't Apply.

Hmmm....As A Short Term Trader, You Still Need To Get Into Good Quality Scrips Or Momentum Plays, Where Your Exit Is Important & Ability To Figure Out Ebbing Of The Momentum.

Most Tale of Woes Are Because Of Momentum Plays.


Happy & Safer Investing

SavantGarde
 

MurAtt

Well-Known Member
Smart Money - would it not reflect in the dollar rates once it starts coming into India. From 50-47. the cmp shows it all -- what say.

I am not at all qualified in AFL and programming and even the econmics BUT just my quarter cent in this --- if we include $ value as a variable into the programming system would it not show inflow and outflow and affect our buys and sells -- somthing like OBV sort of?
 
Status
Not open for further replies.

Similar threads