General Trading Chat

[travi]

whats ur plan for that ?

It'll all happen after market opens so plenty of time to think.
Overnight has no bearing so I'll just catch the trend.

 

[travi]

koi jawab do bhai , searching in nse but there is information only for index

CIRCUIT LIMITS FOR SENSEX AND NIFTY

Check this
https://www.quora.com/What-happens-when-any-stock-hits-the-circuit-limit-in-the-BSE-NSE

 

[Just-Trade]

NF may try touch 8674 now onwards today but may not go above it

Just-Trade

There was a resistance zone around 8674, and Nifty obeyed it today. Nice movement by Nifty

Just-Trade

 

[cinderblock]

Now airtel is largest player. If idea and vodafone combine that will be largest telecom company. PE ratio of airtel is 26.4 and idea is 21.7. So PE of idea shd increase...?

Also airtel has facevalue 5 while idea 10. So idea should be priced atleast half of airtel if deal goes thru ?? So ideally shdnt idea move to 150-180 if deal goes thru..?

PEs are calculated on per share basis (price per share/eps). Face value does not matter.

 

[travi]

CIRCUIT LIMITS FOR SENSEX AND NIFTY

Check this
https://www.quora.com/What-happens-when-any-stock-hits-the-circuit-limit-in-the-BSE-NSE

I think Circuit is not applicable on the stock whose derivative is available ie. future and option trading happens.

 

[lemondew]

Idea at present is cheaper than airtel. But is likely to have more subscribers than airtel and higher revenues if deal goes thru... thats what i am saying
PS: Just guessing not sure about it.....

PEs are calculated on per share basis (price per share/eps). Face value does not matter.

 

[john302928]

Does anyone know the formula to get Previous month OHLC of a stock and previous week OHLC of a stock in google spreadsheet?If so please let me know. Thanks

Can anyone help me with this requirement?please. thanks

 

[travi]

Can anyone help me with this requirement?please. thanks

Can you post spreadsheet with sample data ?

 

[john302928]

Can you post spreadsheet with sample data ?

Dear Travi, I dont know what to provide in the sample data,
I hope you are aware of google finance symbols for google spreadsheet to retrieve stock quotes like OHLC for any stock
I want monthly OHLC of a stock and weekly OHLC of a stock. I want the formula for that.

 

[travi]

Dear Travi, I dont know what to provide in the sample data,
I hope you are aware of google finance symbols for google spreadsheet to retrieve stock quotes like OHLC for any stock
I want monthly OHLC of a stock and weekly OHLC of a stock. I want the formula for that.

Formula is simple but if you share exact sheet than can put formula in it.

Otherwise logically,
Your data will be in a range with dates,
so
1. "Current Date" - 7 will give date_start_w for week
2. "Current Date" - 30 will give date_start_m for month

from that date, you look it up and that range will be data set.
1. Open = open value of date_start
2. high = highest value in the data range
3. low = lowest value in the data range
4. Close=close value of current_date