Exporting TPO data with Spreadsheet study - futures io
futures io futures trading



Exporting TPO data with Spreadsheet study


Discussion in Sierra Chart

Updated
      Top Posters
    1. looks_one Big Mike with 6 posts (1 thanks)
    2. looks_two slickiam with 5 posts (1 thanks)
    3. looks_3 Nicolas11 with 3 posts (4 thanks)
    4. looks_4 justrading with 1 posts (2 thanks)
      Best Posters
    1. looks_one justrading with 2 thanks per post
    2. looks_two Nicolas11 with 1.3 thanks per post
    3. looks_3 slickiam with 0.2 thanks per post
    4. looks_4 Big Mike with 0.2 thanks per post
    1. trending_up 6,913 views
    2. thumb_up 8 thanks given
    3. group 5 followers
    1. forum 13 posts
    2. attach_file 2 attachments




Welcome to futures io: the largest futures trading community on the planet, with well over 125,000 members
  • Genuine reviews from real traders, not fake reviews from stealth vendors
  • Quality education from leading professional traders
  • We are a friendly, helpful, and positive community
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts
  • We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community.  It's free and simple.

-- Big Mike, Site Administrator

(If you already have an account, login at the top of the page)

 
Search this Thread
 

Exporting TPO data with Spreadsheet study

(login for full post details)
  #1 (permalink)
Site Administrator
Swing Trader
Data Scientist & DevOps
Manta, Ecuador
 
Experience: Advanced
Platform: My own custom solution
Trading: Emini Futures
 
Big Mike's Avatar
 
Posts: 49,792 since Jun 2009
Thanks: 32,326 given, 97,628 received

Hi guys,

I'm trying to export TPO chart data (POC, Value Areas) using the Sierra Chart spreadsheet study. But the study is not exporting any TPO plots.

Was wondering if I am missing something, or if there is another way to do this?

Mike

We're here to help -- just ask

For the best trading education, watch our webinars
Searching for trading reviews? Review this list

Follow us on Twitter, YouTube, and Facebook

Support our community as an Elite Member:
https://futures.io/elite/
Follow me on Twitter Visit my futures io Trade Journal Started this thread Reply With Quote

Can you help answer these questions
from other members on futures io?
SimplerOptions
Trading Reviews and Vendors
COTbase for quant trading?
Elite Algorithmic NinjaTrader Trading
What blockvolume is visible? - order processing
NinjaTrader
Work with historical tcks data on MUltichart NET PowerLa …
MultiCharts
Volume Profile Indicator for Ninja Script in NT8
NinjaTrader
 
Best Threads (Most Thanked)
in the last 7 days on futures io
Battlestations: Show us your trading desks!
118 thanks
Big Mike in Ecuador
66 thanks
If you needed one-on-one help with any trading issue, ho …
31 thanks
Want your NinjaTrader indicator created, free?
27 thanks
Building a Crypto Mining Rig
21 thanks
 
(login for full post details)
  #2 (permalink)
Tomsk, Russia
 
Experience: Beginner
Platform: custom
Trading: gold
 
slickiam's Avatar
 
Posts: 272 since Dec 2010
Thanks: 133 given, 433 received


Big Mike View Post
Hi guys,

I'm trying to export TPO chart data (POC, Value Areas) using the Sierra Chart spreadsheet study. But the study is not exporting any TPO plots.

Was wondering if I am missing something, or if there is another way to do this?

Mike

TPO Value Area Lines?

Scientia Libertas Prosperitas
Reply With Quote
 
(login for full post details)
  #3 (permalink)
Site Administrator
Swing Trader
Data Scientist & DevOps
Manta, Ecuador
 
Experience: Advanced
Platform: My own custom solution
Trading: Emini Futures
 
Big Mike's Avatar
 
Posts: 49,792 since Jun 2009
Thanks: 32,326 given, 97,628 received



slickiam View Post
TPO Value Area Lines?

Yes, the VAH, VAL as well as POC.

This can be after-the-fact, for example can plot up to yesterday's date. That is fine, I am doing this for historical study not real-time analysis.

Mike

We're here to help -- just ask

For the best trading education, watch our webinars
Searching for trading reviews? Review this list

Follow us on Twitter, YouTube, and Facebook

Support our community as an Elite Member:
https://futures.io/elite/
Follow me on Twitter Visit my futures io Trade Journal Started this thread Reply With Quote
 
(login for full post details)
  #4 (permalink)
Site Administrator
Swing Trader
Data Scientist & DevOps
Manta, Ecuador
 
Experience: Advanced
Platform: My own custom solution
Trading: Emini Futures
 
Big Mike's Avatar
 
Posts: 49,792 since Jun 2009
Thanks: 32,326 given, 97,628 received

BTW, I need the same thing for Volume by Price.

The Volume Profile study already plots the POC, but it does not plot the Value Areas. It also appears to only plot the 10 most recent POC entries, no idea why only 10. Here is a screenshot of the spreadsheet data.



Mike

We're here to help -- just ask

For the best trading education, watch our webinars
Searching for trading reviews? Review this list

Follow us on Twitter, YouTube, and Facebook

Support our community as an Elite Member:
https://futures.io/elite/
Follow me on Twitter Visit my futures io Trade Journal Started this thread Reply With Quote
 
(login for full post details)
  #5 (permalink)
Tomsk, Russia
 
Experience: Beginner
Platform: custom
Trading: gold
 
slickiam's Avatar
 
Posts: 272 since Dec 2010
Thanks: 133 given, 433 received


Big Mike View Post
BTW, I need the same thing for Volume by Price.

The Volume Profile study already plots the POC, but it does not plot the Value Areas. It also appears to only plot the 10 most recent POC entries, no idea why only 10. Here is a screenshot of the spreadsheet data.



Mike

Yes, indeed ... 10

But are there any problem with TPO Value Area Lines and Volume Value Area Lines?

Scientia Libertas Prosperitas
Reply With Quote
 
(login for full post details)
  #6 (permalink)
Site Administrator
Swing Trader
Data Scientist & DevOps
Manta, Ecuador
 
Experience: Advanced
Platform: My own custom solution
Trading: Emini Futures
 
Big Mike's Avatar
 
Posts: 49,792 since Jun 2009
Thanks: 32,326 given, 97,628 received


slickiam View Post
But are there any problem with TPO Value Area Lines and Volume Value Area Lines?

Yes as I mentioned, none of the plots work in the spreadsheet.

Mike

We're here to help -- just ask

For the best trading education, watch our webinars
Searching for trading reviews? Review this list

Follow us on Twitter, YouTube, and Facebook

Support our community as an Elite Member:
https://futures.io/elite/
Follow me on Twitter Visit my futures io Trade Journal Started this thread Reply With Quote
 
(login for full post details)
  #7 (permalink)
Bangkok, Thailand
 
 
Posts: 59 since Mar 2012
Thanks: 48 given, 50 received


Big Mike View Post
Yes as I mentioned, none of the plots work in the spreadsheet.

Mike

I had this problem with Volume by Price and was advised to add the study "Volume Value Area Lines", which gives me the data I need in the spreadsheet, ie VAH/L and POC.

I also tested the study "TPO Value Area Lines" and it works in similar fashion.

Using SC 867.

Reply With Quote
The following 2 users say Thank You to justrading for this post:
 
(login for full post details)
  #8 (permalink)
near Paris, France
 
Experience: Beginner
Platform: -
Trading: -
 
Nicolas11's Avatar
 
Posts: 1,071 since Aug 2011
Thanks: 2,232 given, 1,751 received

@Big Mike ,

I am aware that this is slightly off-topic, but have you found a way (other than copy-paste of all cells) to export the content of a SC spreadsheet to Excel or another software?

Thanks in advance,

Nicolas

Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #9 (permalink)
near Paris, France
 
Experience: Beginner
Platform: -
Trading: -
 
Nicolas11's Avatar
 
Posts: 1,071 since Aug 2011
Thanks: 2,232 given, 1,751 received

I answer to my own question... ^_^

Actually, my final objective was to import all SC chart information values (price and indicators time series) to R.

The most convenient way that I found to do it is the following.

1) In SC, Prepare a chart with relevant indicators
2) Add Spreadsheet study
3) In the spreadsheet, select all cells (top-left cell) and copy (Ctrl-C)
4) In R, import the clipboard, and process it.

For instance, the following chart could lead to the below xts object:



Nicolas

Visit my futures io Trade Journal Reply With Quote
The following 3 users say Thank You to Nicolas11 for this post:
 
(login for full post details)
  #10 (permalink)
Site Administrator
Swing Trader
Data Scientist & DevOps
Manta, Ecuador
 
Experience: Advanced
Platform: My own custom solution
Trading: Emini Futures
 
Big Mike's Avatar
 
Posts: 49,792 since Jun 2009
Thanks: 32,326 given, 97,628 received



Nicolas11 View Post
@Big Mike ,

I am aware that this is slightly off-topic, but have you found a way (other than copy-paste of all cells) to export the content of a SC spreadsheet to Excel or another software?

Thanks in advance,

Nicolas

Sorry but no. All of my time lately has gone towards developing my own analysis & execution platform in R. Happy to report I am 90% there!

Mike

We're here to help -- just ask

For the best trading education, watch our webinars
Searching for trading reviews? Review this list

Follow us on Twitter, YouTube, and Facebook

Support our community as an Elite Member:
https://futures.io/elite/
Follow me on Twitter Visit my futures io Trade Journal Started this thread Reply With Quote
The following user says Thank You to Big Mike for this post:
 
(login for full post details)
  #11 (permalink)
Tomsk, Russia
 
Experience: Beginner
Platform: custom
Trading: gold
 
slickiam's Avatar
 
Posts: 272 since Dec 2010
Thanks: 133 given, 433 received


Big Mike View Post
... & execution platform in R. Happy to report I am 90% there!
Mike

Hello @Big Mike

Was this info shared somewhere on the forum? /sorry if i've missed it/

ty

Scientia Libertas Prosperitas
Reply With Quote
 
(login for full post details)
  #12 (permalink)
Site Administrator
Swing Trader
Data Scientist & DevOps
Manta, Ecuador
 
Experience: Advanced
Platform: My own custom solution
Trading: Emini Futures
 
Big Mike's Avatar
 
Posts: 49,792 since Jun 2009
Thanks: 32,326 given, 97,628 received


slickiam View Post
Hello @Big Mike

Was this info shared somewhere on the forum? /sorry if i've missed it/

ty

Spread about in various threads in the R section and the MySQL tick thread, but ultimately no I've not made a thread describing entirely what I am doing.

Mike

We're here to help -- just ask

For the best trading education, watch our webinars
Searching for trading reviews? Review this list

Follow us on Twitter, YouTube, and Facebook

Support our community as an Elite Member:
https://futures.io/elite/
Follow me on Twitter Visit my futures io Trade Journal Started this thread Reply With Quote
 
(login for full post details)
  #13 (permalink)
Tomsk, Russia
 
Experience: Beginner
Platform: custom
Trading: gold
 
slickiam's Avatar
 
Posts: 272 since Dec 2010
Thanks: 133 given, 433 received


Big Mike View Post
Spread about in various threads in the R section and the MySQL tick thread, but ultimately no I've not made a thread describing entirely what I am doing.
Mike

Yes, I saw them. Very cool.
A lot of traders from my motherland are doing the same for a Data mining.


Quoting 
I've not made a thread describing entirely what I am doing.

I had no any intentions to touch the privacy.
I'm interested to see yet another example to use SC as an execution platform in conjunction with 3d-party self-made solutions.

Python SCID to TSV / CSV and Pandas DataFrame Conversion - Support Board - Sierra Chart

Python for Sierra Chart - Support Board - Sierra Chart

imho self-made data mining solutions is another proper way to do a job in the nearest future.

So it's awesome.

Scientia Libertas Prosperitas
Reply With Quote
The following user says Thank You to slickiam for this post:
 
(login for full post details)
  #14 (permalink)
near Paris, France
 
Experience: Beginner
Platform: -
Trading: -
 
Nicolas11's Avatar
 
Posts: 1,071 since Aug 2011
Thanks: 2,232 given, 1,751 received


Nicolas11 View Post
Actually, my final objective was to import all SC chart information values (price and indicators time series) to R.

The most convenient way that I found to do it is the following.

1) In SC, Prepare a chart with relevant indicators
2) Add Spreadsheet study
3) In the spreadsheet, select all cells (top-left cell) and copy (Ctrl-C)
4) In R, import the clipboard, and process it.

Related code is posted there:

Nicolas

Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to Nicolas11 for this post:


futures io Trading Community Platforms and Indicators Sierra Chart > Exporting TPO data with Spreadsheet study


Last Updated on December 4, 2013


Upcoming Webinars and Events
 

NinjaTrader Indicator Challenge!

Ongoing
 

Battlestations! Show us your trading desk - $1,500 in prizes!

March
 

Importance of Finding Your Own Way w/Adam Grimes

Elite only
 

Journal Challenge w/Jigsaw

April
     



Copyright © 2021 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, info@futures.io
All information is for educational use only and is not investment advice.
There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
no new posts