OmniTrader Forum OmniTrader Forum
forums calendars search
today this week
 
register logon control panel Forum Rules
You are currently browsing as a guest.
You should logon to access more features
A Self-Moderated Community - ALL MEMBERS, PLEASE READ!
Vote for Members who contribute the most to your trading, and help us moderate content within the Forums.


Only Forum Moderators, Administrators, and the owner of this message may delete it.

 
Vinay

Legend
1001001001002525
Posts: 471

Joined: 12/9/2011
Location: Planet Earth

User Profile
 
Subject : RE: Focus List Excel Export
Posted : 3/13/2017 10:52 AM
Post #40846 - In reply to #40843

There is a better solution but that requires Microsoft Access. The steps below are valid for MS Access 2007. If you have newer version then there might be slight differences which should be easy to figure out.

1. Copy the Profile to a new location and change its extension to ".mdb". In fact the OT Profiles and many other user created/ modified files are basically MS Access database.

2. Double click to open it in MS Access.

3. On the left hand side you will see many Tables which OT creates and updates when we create/ run analysis.

4. Here you will see one Table named "FocusList". Double click to open it.

5. Click "External Data" on the Menu bar.

6. Here you will find a button labeled "Excel". In fact there are 2 similarly named buttons. We are interested in the second Excel button which is at seventh place from left and when you hover mouse over it displays "Export to Excel spreadsheet".

7. Click on the "Export to Excel spreadsheet" button and specify the name and location of the exported file.

8. Done. You have just exported the entire contents of the FocusList to Excel file. There will be many columns which OT uses internally which we don't require. These can be deleted.

Deleting message 40846 : RE: Focus List Excel Export


Nirvana Systems
For any problems or issues please contact our Webmaster at webmaster@nirvsys.com.