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.


  Current location        Thread information  
OmniTrader 2017 Upgrade Forums
OmniTrader Feature Requests
Focus List Excel Export
Last Activity 6/9/2018 1:22 PM
4 replies, 423 viewings

Jump to page : 1
Now viewing page 1 [25 messages per page]
 
back reply
Printer friendly version

^ Top
MAB

Member

Posts: 20

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

Idol
20005001001002525
Posts: 2771

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

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.

^ Top
Jim Dean

Idol
20005001001002525
Posts: 2771

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 ;~)

[Edited by Jim Dean on 3/13/2017 10:55 AM]

^ Top
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: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.

Jump to page : 1
Now viewing page 1 [25 messages per page]
back reply

Legend    Action      Notification  
Administrator
Forum Moderator
Registered User
Unregistered User
E-Mail this thread to a friend
Toggle e-mail notification


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