OmniTrader Forum - OmniTrader Feature Requests
Focus List Excel Export

^ Top
MAB

Posts: 24

Joined: 1/9/2013
Location: Palm Coast

User Profile
 
Subject : Focus List Excel Export
Posted : 3/12/2017 1:45 PM
Post #40843

How about the ability to export the focus list report to Excel?
^ Top
Jim Dean

Posts: 2896

Joined: 9/21/2006
Location: L'ville, GA

User Profile
 
Subject : RE: Focus List Excel Export
Posted : 3/12/2017 2:05 PM
Post #40844 - In reply to #40843

Been requested many times over the years but not implemented.

It's possible with TechSmith's Snagit, to capture a scrolling window such as a long FL, and (with version 9 or earlier, not version 10), to auto-OCR it, converting the images of values to text ... ie snapshotting the FL and getting a delimited text file out of it. Ver.10 can't do the OCR part, since that feature always was a bit persnickety re how you defined capture area, etc. But Ver.9 works reliably enough for me, and I've used it on many occasions.

For now, that's the only solution that I know of.
^ Top
Vinay

Posts: 504

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.

^ Top
Jim Dean

Posts: 2896

Joined: 9/21/2006
Location: L'ville, GA

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

Nice, Vinay!

Does it include Custom columns based on OLang or PlugIn Indicators too?

(I'm too lazy to test ;~)
^ Top
Vinay

Posts: 504

Joined: 12/9/2011
Location: Planet Earth

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

Yes. It includes every column which we can see in the FocusList as well as some additional columns which OT uses internally.



https://www.omnitrader.com/currentclients/otforum/thread-view.asp?threadid=14376&posts=5