Odin Data

sufin · #1 18th August 2006, 11:55 AM

Dear Every One,

I am using Odin for my clients trading, and the problem comes when the day get end. From the day I started my company i am saving my saudas by CCP - Cut Copy Past in Excel File to keep my individual Track record. Every Work sheet is name by my client name & client Id.

I also take online back up it generates file in .txt format.

My problem: Is there any way where my excel file takes the data automatically from .txt file and each and every sauda is saved individually in my clients work sheet.

Thanks,
Sumit Jain

jdm · #2 18th August 2006, 12:25 PM

hi sumit,
what i understand from your problem, instead of making different worksheets for each client put in good use of the "Filter" function in excel.

but since you are in business, its always wise to do business in a professional way. invest in a software, it will keep off a lots of hassles and headache.

cheers,
jdm.

sufin · #3 18th August 2006, 02:47 PM

Thanks for the reply!!!

These small business applications are not available in the market and so one has to either get it done from any of the software vendor or have to make on our own.

What i think to get data from txt format file is easy but is there any other out to solve the problem ?

Thanks

aca_trader · #4 18th August 2006, 02:48 PM

Quote:

Originally Posted by sufin

My problem: Is there any way where my excel file takes the data automatically from .txt file and each and every sauda is saved individually in my clients work sheet.

Thanks,
Sumit Jain

You can open the text file in excel and then use the filter function as suggested by JDM to copy and then paste data in other worksheets. This task can be automated using a macro in excel.

Else, Access has very good solution to your problem. You need to create a table in which daily data is appended. From a parameter query, you can generate client-wise reports w/o duplicating data and thus putting burden on your computer resources.

Best Regards,
--Ashish

cooltetra · #5 18th August 2006, 07:42 PM

Hi Sufin
Try google on features of "import external data in excel". This may help you.
To start with.....
Open excel>>go to data>>import external data>>import data>>change file filter to xls>>and choose the file from which you are copy pasting.
Play with it with the diff options you get.

Hope this helps.

Best Regards
Coool.

cemcompusoft · #6 22nd September 2006, 07:39 AM

Quote:

Originally Posted by sufin

Thanks for the reply!!!

These small business applications are not available in the market and so one has to either get it done from any of the software vendor or have to make on our own.

What i think to get data from txt format file is easy but is there any other out to solve the problem ?

Thanks

Dear Sufin,

If you are still not able to solve your problem ,please PM me or send mail to cemcompusoft@*****.com. We have one software for this purpose, But that is not a freeware.

Regards,

K S Kachhwaha

sufin · #7 22nd September 2006, 01:18 PM

Sorry for the delays.

Thanks for solving my problem.

Regards,
Sufin

sonuarora · #8 26th February 2008, 07:32 PM

hi dudes ihave user code or password for odin client v7.10 plz help me

Similar Threads for: Odin Data
Thread	Thread Starter	Forum	Replies	Last Post
ODIN and its uses	gold_ranjit	Brokers & Demat Matters	66	22nd August 2008 08:58 AM
NSE NEAT/ Odin Diet ????	susheel04	Software	11	15th July 2008 12:10 AM
Odin 7 necessary	Czar	Software	0	16th July 2006 12:05 AM
ODIN Vs Diet ODIN	bluesea	MetaStock	0	8th April 2006 05:51 PM
odin	gopu	Software	2	17th September 2005 10:48 AM