@Punit
But yeah man there is a problem with regard to funding via Bank wire transfer which is why have seen most members use Credit cards , E-currency to fund , pvt banks allow you to fund your overseas fx accounts ?
DEVILISHANGEL SaysBut thats the problem. I need the data, the software analysis is a later part. Whatever i need software wise is doable on excel itself.
NSE data you can get easily for any stocks since the time it started trading. For any analysis , you need the OHLC and traded Volume of X stock for certain number of days. In case of derivatives , you also might need OI (open Interest) . What you are looking for is Bhavcopy . Its released on the NSE site , EOD(end of the day) and is available to all free of cost. If you are looking for 5 yrs past data , it wont be possible to download it day by day manually , like Punit said , just subscribe to any data vendor and you will have access to the required data at a nominal rate. And as long as you stay subscribed , you will get the EOD data directly sent to you by them , no need for manual searching on nSE site.
If you are looking for TA software , go for Amibroker or Metastock eyes closed. For free versions , look at Fibotrader or webotron.
NSE data you can get easily for any stocks since the time it started trading. For any analysis , you need the OHLC and traded Volume of X stock for certain number of days. In case of derivatives , you also might need OI (open Interest) . What you are looking for is Bhavcopy . Its released on the NSE site , EOD(end of the day) and is available to all free of cost. If you are looking for 5 yrs past data , it wont be possible to download it day by day manually , like Punit said , just subscribe to any data vendor and you will have access to the required data at a nominal rate. And as long as you stay subscribed , you will get the EOD data directly sent to you by them , no need for manual searching on nSE site.
If you are looking for TA software , go for Amibroker or Metastock eyes closed. For free versions , look at Fibotrader or webotron.
yeah i need bse data for a period of more than 1 year and ideally 2-3 years.
I need day to day data where i can look at company stock and see how much it moved intraday on that particular day in anyday in the past.
yeah i need bse data for a period of more than 1 year and ideally 2-3 years.
I need day to day data where i can look at company stock and see how much it moved intraday on that particular day in anyday in the past.
Ok , that means you would need bse bhavcopy. Its available on their official site.
@Punit
But yeah man there is a problem with regard to funding via Bank wire transfer which is why have seen most members use Credit cards , E-currency to fund , pvt banks allow you to fund your overseas fx accounts ?
Absolutely no problem 😃 just call up the customer care at FXcentral or IB 😃
Zangetsu SaysOk , that means you would need bse bhavcopy. Its available on their official site.
But that way i have to download for everyday in the past manually :(
can't i get all of it at once?
But thank you, even this (bhavcopy) will help a lot.
btw, why such a weird name? "Bhavcopy"? :|
Also, there is a file attached with this post, please check it out as It will give you the visual of what I exactly want. I need the exact info that is available here and i want it both for profits and losses.
But that way i have to download for everyday in the past manually :(
can't i get all of it at once?
But thank you, even this (bhavcopy) will help a lot.
btw, why such a weird name? "Bhavcopy"? :|
Also, there is a file attached with this post, please check it out as It will give you the visual of what I exactly want. I need the exact info that is available here and i want it both for profits and losses.
Hehe , I dont know either , earlier i also used to think what all these guys are talking about.
File pic is not getting downloaded.
I have query regarding face value.
TCS trades @ 760 while Infy @ 2700, so while direct comparison tells, Infy is costly (both have almost same PE 26-27)
But TCS has face value of Rs.1 while Infy has face value of Rs.5
So one of my friend suggested me that comparison should be made talking into face value factor
Either I make TCS face value 5 (by multiplying CMP * 5) or make Infy face value 1 (by dividing CMP / 5), then only one should compare the shares?
Is he right?
Should we always check whether companies have similar face value while making comparison? At least, moneycontrol.com does not make such.
I have query regarding face value.
TCS trades @ 760 while Infy @ 2700, so while direct comparison tells, Infy is costly (both have almost same PE 26-27)
But TCS has face value of Rs.1 while Infy has face value of Rs.5
So one of my friend suggested me that comparison should be made talking into face value factor
Either I make TCS face value 5 (by multiplying CMP * 5) or make Infy face value 1 (by dividing CMP / 5), then only one should compare the shares?
Is he right?
Should we always check whether companies have similar face value while making comparison? At least, moneycontrol.com does not make such.
Nope. U probably missing the 'No. of shares outstanding' factor. It is quite possible, that infy trading at 2700 and TCS trading at 760 both have face value of 1, but the no. of shares outstanding differs. In short, u should compare their market capitalisation
(Remember, market cap = current market price * no. of shares outstanding)
For comparing , it boils down to PE ratio.
(Remember, P/E = CMP / EPS or Market Cap / Profit after tax.)
Nope. U probably missing the 'No. of shares outstanding' factor. It is quite possible, that infy trading at 2700 and TCS trading at 760 both have face value of 1, but the no. of shares outstanding differs. In short, u should compare their market capitalisation
(Remember, market cap = current market price * no. of shares outstanding)
For comparing , it boils down to PE ratio.
(Remember, P/E = CMP / EPS or Market Cap / Profit after tax.)
But I read somewhere on net that Infy planning to opt for stock split soon and thus it share will soon trade @ of face value 1.
In that case, Infy price will be around 540 or so, which is pretty less than TCS.
Thus in this case, are we making correct comparison or face value factor has nothing to do while making an investment decision.
But I read somewhere on net that Infy planning to opt for stock split soon and thus it share will soon trade @ of face value 1.
In that case, Infy price will be around 540 or so, which is pretty less than TCS.
Thus in this case, are we making correct comparison or face value factor has nothing to do while making an investment decision.
Face Value is of no use in valuation. Go by PE ratio and future growth opportunities by companies. I feel both TCS n Infy r excellent companies, but infy is slightly better. But only slightly. Its high time infy should consider a stock split and bonus. If u believe wat u read is true, its time to purchase infy now and gain decently in near future.
Reliance Natural ( RNRL ) , Reliance Power merger news is hot now.
Reliance group firms have been constantly merging and demerging business.
Reliance power was carved out of Reliance infrastructure. Now RNRL and Rel Power are merging this time.
While the companies did not disclose any details of the proposed merger, some brokers said that rumours are about a share-swap deal with four shares of RNRL for every one R-Power share. Currently, the two stocks have market values in the ratio of about 1:3.
The announcement is significant as it comes close on the heels of the two Ambani siblings rescinding a long-standing non-compete agreement, allowing them to expand into each other's sectors.
Also, last week Reliance Industries Ltd. (RIL) and RNRL signed a new gas supply master agreement (GSMA) pursuant to the judgment of the Supreme Court, dated May 7.
ADAG has betrayed the retail investors by approving such a pathetic swap ratio.:oops: The stock plummeted by more than 27% in a single day.:-( The clever thing done by ADAG was announcement of Merger on Sunday. They hardly gave retail investors time to exit the stock. This merger better be called Murder of Invetor Sentiments.:banghead:
A nice write up on the issue by an expert.
"This Merger announcement looks to me a clear case of ADAG Group and management of both companies doing this for their own benefits as ADAG is major stockholder in this. As per the news KPMG has done the valuation. It looks like same case as Satyam wheremanagement said they have got the valuation done from an independent valuer for Maytas buyout or merger with Satyam.
As per my understanding this is not in the interest of Minority Shareholders. If these would have been two different companies not under same management/owner there would have been a sharp up move in the RNRL and management would have sold this company at much higher premium as seen in the case of Reliance Infratel merger deal with GTL Infra.
The price of RNRL expected to fall by 20% on Monday due to this news and minority shareholders would lose a lot of money. Does anyone on this board know about SEBI Act that what actions can be taken by Minority Shareholders to stop this merger?
The job of management is to work in the interest of all shareholders not only owners. How can management of RNRL agree on 4:1 swap ratio which is around the 52 week low of RNRL after SC decision in RIL: RNRL case?
My feeling is we should not sell the shares in panic as RNRL is expected to open around Rs. 40 to 45. So there is no point in selling it at low and booking the loss. Instead we should hold the shares and buy more at fall. This will increase shareholding of Minority shareholders. Then we should come together and appeal against this merger deal in SEBI, MCA and further a PIL in the Court. By doing this we can manage to get a better deal, but we may have to hold our shares for a longer term.
If RPOWER Doesn`t merge the RNRL they would not be allotted the GAS as per the agreement between RIL:RNRL. So they`ll lose more as they`ll have to buy GAS from market at higher price as per the recent rate fixed by Govt. for ONGC`s GAS at about more than US $ 5 per mmbtu.
Instead of merger with RPOWER RNRL management can buy the GAS Power assets of RPOWER or start their own Power plants as the status is same as the RPower even they need to start their mega projects. Other option is to merge RPOWER in RNRL and give RPOWER shareholders 2.5 shares (about 20% discount on Fridays close) of RNRL for 1 share in RPOWER.
See minority shareholders have always taken hit due to fraud by management / owners and continue to do so unless we come together and highlight this matter. We may lose the case but if we win the case we can setup an example for othercompanies and minimize the future loses for small investors.
The price of RNRL expected to fall by 20% on Monday due to this news and minority shareholders would lose a lot of money. Does anyone on this board know about SEBI Act that what actions can be taken by Minority Shareholders to stop this merger?
The job of management is to work in the interest of all shareholders not only owners. How can management of RNRL agree on 4:1 swap ratio which is around the 52 week low of RNRL after SC decision in RIL: RNRL case?
My feeling is we should not sell the shares in panic as RNRL is expected to open around Rs. 40 to 45. So there is no point in selling it at low and booking the loss. Instead we should hold the shares and buy more at fall. This will increase shareholding of Minority shareholders. Then we should come together and appeal against this merger deal in SEBI, MCA and further a PIL in the Court. By doing this we can manage to get a better deal, but we may have to hold our shares for a longer term.
If RPOWER Doesn`t merge the RNRL they would not be allotted the GAS as per the agreement between RIL:RNRL. So they`ll lose more as they`ll have to buy GAS from market at higher price as per the recent rate fixed by Govt. for ONGC`s GAS at about more than US $ 5 per mmbtu.
Instead of merger with RPOWER RNRL management can buy the GAS Power assets of RPOWER or start their own Power plants as the status is same as the RPower even they need to start their mega projects. Other option is to merge RPOWER in RNRL and give RPOWER shareholders 2.5 shares (about 20% discount on Fridays close) of RNRL for 1 share in RPOWER.
See minority shareholders have always taken hit due to fraud by management / owners and continue to do so unless we come together and highlight this matter. We may lose the case but if we win the case we can setup an example for othercompanies and minimize the future loses for small investors. "
Looks like people lost much money in RNRL. Well buddy don't worry there are people who are waiting to buy RNRL at 40 tomarrow. Btw don't you think Anil Ambani's companies are a hell lot risky. All said and done praying for RNRL to come below 40 to buy it.
vishnu sharma SaysLooks like people lost much money in RNRL. Well buddy don't worry there are people who are waiting to buy RNRL at 40 tomarrow. Btw don't you think Anil Ambani's companies are a hell lot risky. All said and done praying for RNRL to come below 40 to buy it.
Yeah certainly... RNRL can be a good buy below 40 or even at this price. ADA himself has huge holding in Reliance power so he will make sure stock will go up. And with the issues sorting out with big brother, RPower will give good returns in long run.
What I didnt like is the way ADA is playin with PPL. Its bcoz of his father's goodwill, PPL blindly invest in IPOs of comapnies like RNRL and RPower. The valuation is such that it cant be explained. RNRL is a company just on paper. Still PPL invest in that. And one day suddenly they announce of such a useless swap ratio and price is down by 30% in a day. Didnt ADA have an idea abt what would happen in Markets after announcement. For him, its like transferring cash from one pocket to another one as both companies are his own. I dont think PPL would want to invest in ADAG IPOs henceforth. ADA was clever enough to sense the investor sentiment, he didnt go for Reliance Infratel IPO, which would hv been a big flop.
Yeah certainly... RNRL can be a good buy below 40 or even at this price. ADA himself has huge holding in Reliance power so he will make sure stock will go up. And with the issues sorting out with big brother, RPower will give good returns in long run.
What I didnt like is the way ADA is playin with PPL. Its bcoz of his father's goodwill, PPL blindly invest in IPOs of comapnies like RNRL and RPower. The valuation is such that it cant be explained. RNRL is a company just on paper. Still PPL invest in that. And one day suddenly they announce of such a useless swap ratio and price is down by 30% in a day. Didnt ADA have an idea abt what would happen in Markets after announcement. For him, its like transferring cash from one pocket to another one as both companies are his own. I dont think PPL would want to invest in ADAG IPOs henceforth. ADA was clever enough to sense the investor sentiment, he didnt go for Reliance Infratel IPO, which would hv been a big flop.
yup true buddy......was thinking just the same...................cheers
Market Seems to be range bound for last few days. Selling a strangle seems a good strategy for July expiry. wat say?
Yeah truly said ABCLIKS
Hey ppl i'd one query.
May sound li'l simple but i'm new and learning slowly.
Bharti was given less credit rating in S&P.; I din't understand why it has been given less rating? Earlier it'd BBB n i suppose its BB!
Why so? Rather we see a rise in markt cap and share price wen a company acquires another company.
Yeah truly said ABCLIKS
Hey ppl i'd one query.
May sound li'l simple but i'm new and learning slowly.
Bharti was given less credit rating in S&P.; I din't understand why it has been given less rating? Earlier it'd BBB n i suppose its BB!
Why so? Rather we see a rise in markt cap and share price wen a company acquires another company.
Am not exactly sure about the calculations here but rating is some what similar to SWOT analysis. So you don't merely look at the opportunities but also the Threat/risk Bharati is going to take in this deal which in S&P;'s view/calculations is outweighing the potential benefits for the moment.
Btw if I remember correctly Tata Steel's share price went southwards on the news of Chorus's acquisition, so even secondary market endorses this SWOT to an extend.
ANdy
Bharti surged after they were upgraded by Credit Suisse Group AG.
Bharti, Indias largest mobile-phone operator, jumped the most in 13 months after Credit Suisse raised their ratings to outperform, citing stable tariffs and reduced prospects of further price wars. Tariffs are no longer falling and the new players havent made a dent.
Bhartis shares have the potential to reach 350 rupees in a year, Motilals Sonthalia says.
Prior to yesterday's rally, Bharti shares had declined 29 percent over 12 months Indias telecom stocks were upgraded at Credit Suisse saying tariffs have been stable over the past eight months and the cost of acquiring high-speed third-generation bandwidth will crimp the ability of challengers to go for another price war.