The CHIT CHAT THREAD

[tanewbie]

Film Lagaan remake by Rajnikant climax:

1 ball 24 runs needed. Bowler bowls, Rajniappa hits,then ball splits into 4 pieces.All pieces go for sixes, India wins

 

[learn2trade08]

dear faith,sorry am in a hurry...
hope this helps...

Hi
Can we do technical analysis of ulip plans (unit linked of insurance plans).I am attaching daily data of LIC's Bima Plaus Policy Risk fund.It has only daily prices as there is no daily open ,high,low,close and volume or we can say daily close price.
How can I convert the excel sheet attached so can I upload it on some software ,Amibroker or Fibotrader.
can I put the same figures of daily data in open,high,low,close column and leave the volume column empty.
The idea is to upload this data on software and do the TA as we do in other scrips and instead of shorting or going long here we can change the fund ,like risk to secured and vice versa

faith

 

[orderflow13]

Hi
Can we do technical analysis of ulip plans (unit linked of insurance plans).I am attaching daily data of LIC's Bima Plaus Policy Risk fund.It has only daily prices as there is no daily open ,high,low,close and volume or we can say daily close price.
How can I convert the excel sheet attached so can I upload it on some software ,Amibroker or Fibotrader.
can I put the same figures of daily data in open,high,low,close column and leave the volume column empty.
The idea is to upload this data on software and do the TA as we do in other scrips and instead of shorting or going long here we can change the fund ,like risk to secured and vice versa

faith

Great idea Faith, yes we can do that, what i use it for option open interest you can do it same , open notepad> write like this
BPRF,20081117,30.12,30.12,30.12,30.12,0
BPRF,20081118,30.46,30.46,30.46,30.46,0

... so on.. then save file as BPRF, done , now open amibroker ( if u use diff sw, then adjust date format likewise) and import this data to ami, and in view do it as a line chart ( candle or bar chart wont work as we dont have diff o,h,l,c value ) you will get the chart, u can apply any indicator u want.
But prob is you tracking only bima plus risk free fund, n updating data, for shifting fund you need to track other funds as well.Once i saw on moneycontrol that they tracking fund performance , might useful 4 u
edit.... oops l2t already done with the chart n posted. you guys r too fast, amazing

 

[faith]

dear faith,sorry am in a hurry...
hope this helps...

Hi learn2trade
Thanks a lot this is what I wanted ,now the only problem left is how to convert the data so that I can upload it on fibotrader or amibroker .Please guide me whenever you get the time .Thanks again
faith

 

[orderflow13]

Film Lagaan remake by Rajnikant climax:

1 ball 24 runs needed. Bowler bowls, Rajniappa hits,then ball splits into 4 pieces.All pieces go for sixes, India wins

lol lol lolzzzz

 

[faith]

Great idea Faith, yes we can do that, what i use it for option open interest you can do it same , open notepad> write like this
BPRF,20081117,30.12,30.12,30.12,30.12,0
BPRF,20081118,30.46,30.46,30.46,30.46,0

... so on.. then save file as BPRF, done , now open amibroker ( if u use diff sw, then adjust date format likewise) and import this data to ami, and in view do it as a line chart ( candle or bar chart wont work as we dont have diff o,h,l,c value ) you will get the chart, u can apply any indicator u want.
But prob is you tracking only bima plus risk free fund, n updating data, for shifting fund you need to track other funds as well.Once i saw on moneycontrol that they tracking fund performance , might useful 4 u
edit.... oops l2t already done with the chart n posted. you guys r too fast, amazing

Thanks alex
For close and low price learn2trade has used last day's figure so bar and candlesticks are possible .I was just trying to check if charting of ulips is possible and learn2trade has given the chart so possible now ,yes i have data of all funds of all companies so will upload data and and try TA
thanks
faith

 

[learn2trade08]

dear faith...
there is not a lot to do....all you have to do is use the same excel file,use import wizard>do the usual thingfor ticker/date and use the quote for closing price,and skip the rest like open/high/low and upload data...
once u finish uploading look at weekly's....u will get candle pattern or look for weekly timeframe,then u get open high low close for plotting...
or u can change the settings for line AND ANALYSE THE DAILY CHARTS.
hope this helps

Hi learn2trade
Thanks a lot this is what I wanted ,now the only problem left is how to convert the data so that I can upload it on fibotrader or amibroker .Please guide me whenever you get the time .Thanks again
faith

 

[faith]

dear faith...
there is not a lot to do....all you have to do is use the same excel file,use import wizard>do the usual thingfor ticker/date and use the quote for closing price,and skip the rest like open/high/low and upload data...
once u finish uploading look at weekly's....u will get candle pattern or look for weekly timeframe,then u get open high low close for plotting...
or u can change the settings for line AND ANALYSE THE DAILY CHARTS.
hope this helps

Thanks learn2trade,alex
this is how charts look like
line chart

[/URL]

[/IMG]

 

[faith]

bar chart

[/URL]

[/IMG]

 

[faith]

and candlesticks

[/URL]

[/IMG]
thanks learn2trade,thanks alex and columbs too I got his pm
faith