How to calculate ASI or RSR?

swingtrader · #11 3rd June 2005, 06:16 PM

Quote:

Originally Posted by chheda

Thanks swingtrader for file , the file is in nsc-stock-rank.sxc format will u please give me idea how to open it or a software in which i can open it.

Regards
Harish Chheda

It is OpenOffice spreadsheet file. You will need to install the free software OpenOffice (www.openoffice.org) to view it. I will try and see if I can convert it to an excel spreadsheet. If I can then I will email it to you. Do you have Excel installed on your PC?

--SwingTrader

chheda · #12 4th June 2005, 06:31 PM

Thanks Swing Trader for Excel convertion

Harish Chheda

#13 4th June 2005, 07:53 PM

Quote:

Originally Posted by swingtrader

It is OpenOffice spreadsheet file. You will need to install the free software OpenOffice (www.openoffice.org) to view it. I will try and see if I can convert it to an excel spreadsheet. If I can then I will email it to you. Do you have Excel installed on your PC?

--SwingTrader

Thanx ,I got your mail.
But which version from www.openoffice.org is to download.
Can you provide path?

joy_mitali · #14 4th June 2005, 11:05 PM

Hi Swingtrader,
If u will kindly mail a copy of both the .cvs and .xls file to me,I will be highly obliged---Also if u kindly mail the code for auto-downloading bhavcopy,I will also be greatful to u---- purely educational purpose----My email id:joy_mitali@yahoo.co.in

Regards,
joy_mitali

swingtrader · #15 5th June 2005, 09:04 AM

Quote:

Originally Posted by bhavana

Thanx ,I got your mail.
But which version from www.openoffice.org is to download.
Can you provide path?

I have emailed you the path and also the excel spreadsheet (if you don't want to download openoffice and have excel already installed on your pc).

--SwingTrader

chheda · #16 5th June 2005, 11:25 AM

Hi Swingtrader,
if u kindly mail the code for auto-downloading bhavcopy .

Thanks in Advance,
Harish Chheda
hkchheda@gmail.com

AMITBE · #17 5th June 2005, 04:33 PM

Hi Swingtarder,
I have collected Bhavcopy/closing prices since March 1 2004 in Excel, and now update the daily closing. I am sure you are aware of the problems of doing this daily since scrips get dropped, added on, names change etc. To overcome this I have worked with a friend and written Macros that reconciles the names of scrips via VLOOKUP and so I have an error free copy. At the same time within the same file another page calculates 20, 50, 200 DMA, highlighting the scrips crossing these averages. For easy reference, the preceding 6 day prices are posted against the scrips and their moving averages so one can readily see whether the averages are being crossed from above or below. Another page in the same file calculates the Pivots for all the scrips. I'm quite pleased with the file!! I'm certain you'll figure out the commands.
Hey, but yours seems really cool that auto downloads and updates. Would you explain how buddy? And perhaps send the program?
Thanks.

swingtrader · #18 5th June 2005, 05:18 PM

Quote:

Originally Posted by AMITBE

Hi Swingtarder,
I have collected Bhavcopy/closing prices since March 1 2004 in Excel, and now update the daily closing. I am sure you are aware of the problems of doing this daily since scrips get dropped, added on, names change etc. To overcome this I have worked with a friend and written Macros that reconciles the names of scrips via VLOOKUP and so I have an error free copy. At the same time within the same file another page calculates 20, 50, 200 DMA, highlighting the scrips crossing these averages. For easy reference, the preceding 6 day prices are posted against the scrips and their moving averages so one can readily see whether the averages are being crossed from above or below. Another page in the same file calculates the Pivots for all the scrips. I'm quite pleased with the file!! I'm certain you'll figure out the commands.
Hey, but yours seems really cool that auto downloads and updates. Would you explain how buddy? And perhaps send the program?
Thanks.

Wow! you seem to have done quite a bit of work on your spreadsheet. Actually, I do only the last 5% of the work in the spreadsheet (I have not done much macros programming too). I have a PostgreSQL database that has all the historical data. I have a program that updates this database on a daily basis. The relative strength ranking spreadsheet is just one of the spreadsheets that I generate regularly. Once generated I put in the ranking formulas manually. My spreadsheet does not do any automatic updates etc.

--SwingTrader

joy_mitali · #19 5th June 2005, 05:57 PM

Hi AMITBE,
Will u plz send ur EXcel file --with the macros----I would love to have a peep in it---
Mial-ID:joy_mitali@yahoo.co.in
To SwingTrader:Thanks !!!
Regards,
joy_mitali

AMITBE · #20 6th June 2005, 09:51 AM

Hi Joy,
I would gladly share the file with you except it's quire large and perhaps not so good through email.
I believe you are in Calcutta...and I'm in Hyderabad.
I could mail it.
Regards.

Similar Threads for: How to calculate ASI or RSR?
Thread	Thread Starter	Forum	Replies	Last Post
How to Calculate "Relative Strength" & "Volatility"?	shrees	Technical Analysis	6	22nd July 2008 10:21 PM
Calculate your trade size	CreditViolet	Software	9	11th June 2008 08:18 PM
To Calculate	uncle sam	Technical Analysis	2	11th September 2004 07:54 PM