OmniTrader Professional Forum OmniTrader Professional 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 Pro Resource Forum
OmniTrader Pro Technical Support
Exporting Data to Spreadsheet
Last Activity 2/23/2018 2:23 PM
4 replies, 303 viewings

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

^ Top
ZMTLock

Member

Posts: 11

Joined: 1/31/2016

User Profile
 
Subject : Exporting Data to Spreadsheet
Posted : 6/9/2017 10:51 AM
Post #29578

Does anyone know how to export data from OmniTrader to and Excel spreadsheet? Like the high, low, indicator values, etc.? It would be extremely appreciated. Heck, I'd even pay for it.

[Edited by ZMTLock on 6/9/2017 10:55 AM]

^ Top
Barry Cohen

Icon
10005001001001002525
Posts: 1857
Online

Joined: 1/1/1900

User Profile
 
Subject : RE: Exporting Data to Spreadsheet
Posted : 6/9/2017 2:24 PM
Post #29579 - In reply to #29578

Hopefully we can add this into OT someday. But in the software you cannot export the column data. There is a way however, but you need Microsoft Excel or Access & the data you need has to be Focus List columns with the analysis already ran. You can add indicator columns though if you need them.

Close OT. Browse to the ...Nirvana/OT2017/Profiles folder. Change the extension of your profile from .otp to .mdb

Then open the file with Excel or Access. You'll then want to open the Focus List table. From there you can get the column data you're looking for.

^ Top
ZMTLock

Member

Posts: 11

Joined: 1/31/2016

User Profile
 
Subject : RE: Exporting Data to Spreadsheet
Posted : 6/9/2017 3:22 PM
Post #29580 - In reply to #29578

Ok thanks! Quick question. How do I code the data for the bar(s) after?

Like the bars before are C [2], L[1], etc. Anything for the bars after a signal?
^ Top
Jim Dean

Sage
20001000100
Posts: 3111

Joined: 3/13/2006
Location: L'ville, GA

User Profile
 
Subject : RE: Exporting Data to Spreadsheet
Posted : 6/9/2017 3:24 PM
Post #29581 - In reply to #29579

Barry is right, but afaik that only provides a snapshot of a single bar (typically the HRE). If that's what you are looking for, the route he suggested is a good one to take.

However if you want an "array" of data such as the ohlcv plus indicators for all loaded bars in a text/xls format, that's not possible through any standard N platform interface function that I know of. It can be done via OLang but the code is outside the normal scope of supported functions.
^ Top
Jim Dean

Sage
20001000100
Posts: 3111

Joined: 3/13/2006
Location: L'ville, GA

User Profile
 
Subject : RE: Exporting Data to Spreadsheet
Posted : 6/9/2017 4:18 PM
Post #29582 - In reply to #29581

ZMTLock, please check your PM (private mail)
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.