Click here to Login





                                                   Can Pivot Tables run my symbols in the order provided? (not sorted)

  1

0
Josh McCormick
2020-08-18 17:47:40


I'm happy to say that I've gotten the pivot tables to do what I wanted, but it is creating a lot of extra work after the fact because my symbols (provided as rows) are being sorted into alphabetical order. Is there any way around this?


QuantShare
2020-08-20 11:24:29

  0

Not sure I understand the problem here.


Josh McCormick
2020-08-20 11:35:00

  1

A picture is worth a thousand words. So I'll use TWO pictures. :)

SCREENSHOT: https://i.imgur.com/htl74as.png

Here's my pivot table. All of symbols but "BIL" are custom, but that doesn't impact the issue. After entering my symbols in the order I want, I had hit the [Run Pivot Table] button and you see the results on the lower half of the screenshot. The symbols were resorted into alphabetical order. I believe I see the reason why. After clicking on Columns: [Formula] and back to Rows: [Symbols], my symbols are now listed (and apparently stored) in alphabetical order. Let me show you.

SCREENSHOT: https://i.imgur.com/YrQWkW4.png

It seems that my symbols have been sorted into alphabetical order, like it or not, because they're being stored that way? I'm not sure if you'd consider it a bug or a misfeature, but my strong preference is for sorting NOT to be applied over my symbols (unless I somehow ask for it).

Hope this helps explain the issue better. It causes issues when I go to integrate these results back into other spreadsheets where the symbols are going to be in the original order.

PS: As an enhancement request, it really would be useful to be able to sort the pivot table in various ways. But it isn't a high priority if it's going to be a significant effort.

Thanks,
Josh McCormick




QuantShare
2020-08-24 12:43:25

  1

Best Answer
Thank you for the explanation. We will update that behavior in the next release.


No more messages
0




Reply:

No html code. URLs turn into links automatically.

Type in the trading objects you want to include: - Add Objects
To add a trading object in your message, type in the object name, select it and then click on "Add Objects"










QuantShare

Trading Items
Ticker Symbols List of the National Stock Exchange, NSE, India
Pivot Point Breakout Scanner
Trading Strategy based on the Number of Buy Signals
Tweet Sentiment Index for the Forex and Stock Market
Update the Stock Exchange Associated With U.S. Stocks - Market Fi...

How-to Lessons
How to run a screen or a watchlist from a script
How to display the number of notes per stock
How to plot two different time frames in the same chart
How to get stocks for a particular index using the global script
How to set order type of a trading system programmatically

Related Forum Threads
Ranking using Pivot Tables
Can I update the sector and industry information in the stock dat...
pivot tables
Export to CSV the whole database including symbols
Can I predict values in the future

Blog Posts
How to Display the Year-to-Date Excess Return in a Pivot Table
Pivot Tables in QuantShare Trading Software
Create a Pivot Table that displays the Relative Strength Index - ...
How to predict and trade the stock market using pivot points
QuantShare Trading Software: New Features in the 3.4.2 Version









QuantShare
Product
QuantShare
Features
Create an account
Affiliate Program
Support
Contact Us
Trading Forum
How-to Lessons
Manual
Company
About Us
Privacy
Terms of Use

Copyright 2020 QuantShare.com
Social Media
Follow us on Facebook
Twitter Follow us on Twitter
Google+
Follow us on Google+
RSS Trading Items



Trading financial instruments, including foreign exchange on margin, carries a high level of risk and is not suitable for all investors. The high degree of leverage can work against you as well as for you. Before deciding to invest in financial instruments or foreign exchange you should carefully consider your investment objectives, level of experience, and risk appetite. The possibility exists that you could sustain a loss of some or all of your initial investment and therefore you should not invest money that you cannot afford to lose. You should be aware of all the risks associated with trading and seek advice from an independent financial advisor if you have any doubts.