NexusFi: Find Your Edge


Home Menu

 





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 Big Mike with 0.2 thanks per post
    4. looks_4 slickiam with 0.2 thanks per post
    1. trending_up 9,146 views
    2. thumb_up 8 thanks given
    3. group 5 followers
    1. forum 13 posts
    2. attach_file 2 attachments




 
Search this Thread

Exporting TPO data with Spreadsheet study

  #1 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,399 since Jun 2009
Thanks Given: 33,175
Thanks Received: 101,541

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 the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
The space time continuum and the dynamics of a financial …
Emini and Emicro Index
ZombieSqueeze
Platforms and Indicators
Futures True Range Report
The Elite Circle
Ninja Mobile Trader VPS (ninjamobiletrader.com)
Trading Reviews and Vendors
Better Renko Gaps
The Elite Circle
 
  #2 (permalink)
 
slickiam's Avatar
 slickiam 
Tomsk, Russia
 
Experience: Beginner
Platform: custom
Trading: gold
Posts: 273 since Dec 2010
Thanks Given: 133
Thanks Received: 435


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
  #3 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,399 since Jun 2009
Thanks Given: 33,175
Thanks Received: 101,541



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 the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Started this thread Reply With Quote
  #4 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,399 since Jun 2009
Thanks Given: 33,175
Thanks Received: 101,541

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 the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Started this thread Reply With Quote
  #5 (permalink)
 
slickiam's Avatar
 slickiam 
Tomsk, Russia
 
Experience: Beginner
Platform: custom
Trading: gold
Posts: 273 since Dec 2010
Thanks Given: 133
Thanks Received: 435


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
  #6 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,399 since Jun 2009
Thanks Given: 33,175
Thanks Received: 101,541


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 the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Started this thread Reply With Quote
  #7 (permalink)
justrading
Bangkok, Thailand
 
Posts: 59 since Mar 2012
Thanks Given: 48
Thanks Received: 55


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
Thanked by:
  #8 (permalink)
 
Nicolas11's Avatar
 Nicolas11 
near Paris, France
 
Experience: Beginner
Platform: -
Trading: -
Posts: 1,071 since Aug 2011
Thanks Given: 2,232
Thanks Received: 1,769

@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 NexusFi Trade Journal Reply With Quote
  #9 (permalink)
 
Nicolas11's Avatar
 Nicolas11 
near Paris, France
 
Experience: Beginner
Platform: -
Trading: -
Posts: 1,071 since Aug 2011
Thanks Given: 2,232
Thanks Received: 1,769

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 NexusFi Trade Journal Reply With Quote
Thanked by:
  #10 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,399 since Jun 2009
Thanks Given: 33,175
Thanks Received: 101,541



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 the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Started this thread Reply With Quote
Thanked by:




Last Updated on December 4, 2013


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
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.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts