Excel Formula

cool_archie · #1 26th June 2008, 01:54 PM

Hello Everybody,

Can some one pls mention the excel formula to get days closing sensex & nifty quotes in excel.

Regards,
Archie

rakeshluthra430 · #2 26th June 2008, 02:27 PM

Quote:

Originally Posted by cool_archie

Hello Everybody,

Can some one pls mention the excel formula to get days closing sensex & nifty quotes in excel.

Regards,
Archie

Please rephrase your question...you want to 'transfer' data or need a 'formula' for something??

pl ask again

anand · #3 27th June 2008, 07:00 PM

can sombody say how we convert csv file to access database file

columbus · #4 27th June 2008, 11:44 PM

Quote:

Originally Posted by anand

can sombody say how we convert csv file to access database file

simple.open the file using EXCEL and from FILE menu select SAVE AS and save it in the any other format by choosing with SAVE TYPE in desired place with a file name of your choice.

sharmaaashish · #5 28th June 2008, 12:08 AM

Quote:

Originally Posted by anand

can sombody say how we convert csv file to access database file

is it only few or many csv files.

If few than better do it manualy by saving them to excel file first , then create a new blank MS acess data and then import all those excel files in to ms access database.

Although you can directly import csv files but then first line will not be saved as colum heading in access table.

But if u have csv files which needed to convert then must have to write programing to do it , I made in ASP for which webserver is required , if u need that than i will send u

anand · #6 29th June 2008, 12:24 PM

is it only few or many csv files.

If few than better do it manualy by saving them to excel file first , then create a new blank MS acess data and then import all those excel files in to ms access database.

Although you can directly import csv files but then first line will not be saved as colum heading in access table.

But if u have csv files which needed to convert then must have to write programing to do it , I made in ASP for which webserver is required , if u need that than i will send u

Thanks sir your valuable guidance i am in badly need of it if u have the utility plz mention here so as to use for many member one thing more sir if learned member can assist in puting their views over the term use in TA BRAKE OUT
wht is price brake out , wht is volumn brake out ? can we club both of them for getting trade idea ? Can we make it in EXCELL throug EOD or And Intra day data

anand · #7 29th June 2008, 01:04 PM

Sir if learned member can assist in puting their views over the term use in TA BRAKE OUT
wht is the price brake out , wht is volumn brake out ? can we club both of them for getting trade idea ? Can we make it in EXCELL throug EOD or And Intra day data pls help me out

sharmaaashish · #8 30th June 2008, 10:10 PM

Quote:

Originally Posted by anand

Sir if learned member can assist in puting their views over the term use in TA BRAKE OUT
wht is the price brake out , wht is volumn brake out ? can we club both of them for getting trade idea ? Can we make it in EXCELL throug EOD or And Intra day data pls help me out

Volume breakout out simply means high volumes in any stock say for example double volumes that what is normally traded on other days , but how to comput since we can not ccompare from just last day, because may be on last day volumes were low.

So we have to find out Average trading volumes first any criteria you take either 10 days trading volumes average of 15 days volumes average.

And when ever their is stock traded say double or more than this 15 days average trading volumes its called as Volumes break out.

Price break out is easy to understand and calculate , it up to how much break out u want it can be more than 4 % gain on prev .cloing price or more its ur choice .
Regarding combination of these 2 items , this is very commany application and includes in almost every software, as told in other trade of eodsoft downloaded that 999/- year software , even that have this application.

Some times it works and some times do not work sepending on market situation, but this analysis is good for BTST because these types of stocks normally fire in first few minutes of opening bell and after that they go down.

Just for some laughter : now a days full form of BTST is Buy today sucide tomorrow

But TA breakout is different thing , it means breaking some technical resitance, may be some triangle or some dma-ema levels or may be something else

Regarding ur query of access file , please tell me what is ur colum details means its just same as End of day bhave copy or something extra so that i can coustomised according to that and can give in weekend before that it may not be possible for me .

Your query suggests that you are making an EOD software, man why are u creating so much competition for Sweta and Eodsoft. If every one will make then who will buy

anand · #9 1st July 2008, 10:13 AM

Thank u lot sir, for detail defination of PBo i read this term mostly in ET-newspaper and other financial mag. I want to convert EOD of bhavcopy from NSE to access dbf. Thanks again

sharmaaashish · #10 1st July 2008, 02:13 PM

Quote:

Originally Posted by anand

Thank u lot sir, for detail defination of PBo i read this term mostly in ET-newspaper and other financial mag. I want to convert EOD of bhavcopy from NSE to access dbf. Thanks again

bro csv, access and dbf are 3 different things , earlier u said u need help on how to convert csv into msaccess now from wehere dbf comes into between ????