Click here to Login

                                                   Equivalent of an Amibroker Exploration


2020-09-13 08:45:57

I used to use Amibroker, until realising how great Quantshare is!
one of the things i used the most with Amibroker was an exploration
I could really easily for one instrument get a list of all the monthly closes with the values of indicators at that point in time
or the values for other timeframes
the nearest equivalent is the screener, and the use of addcolumn
but i dont want the last value, or one value, I want all the values so that i can then export them to excel

how could i achieve this best in Quantshare?

thanks all

2020-09-14 11:35:38



You can try the pivot table tool. You can do plenty of things with this.
"Analysis -> Pivot Tables"

TO display for example the daily close price for multiple symbols and dates.
Add a "Symbols" row then a "Dates" row. Leave "Columns" empty and add a "Values" field with "variable = close;"
There you can also specify the dates which will be used to analyze the data.

2020-09-14 12:13:25


What I want to do is display in 1 column the closing monthly prices for just one symbol, then another column would be the ROC(12) for example
I can get the symbol and a value and its a monthly value, however the pivot has a rebalancing that i think could be the issue, as its only set for daily
where even though my time period is set for monthly, it still returns daily amounts
it would good to have a way of just displaying weekly or monthly information, as an added feature

thanks for the suggestion

2020-09-17 10:29:33


Sure, we will add this to our todo list. Thank you.

No more messages


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"


Trading Items
Gann Trend Indicator
Custom High/Low Range
TSI indicator by Frank Hassler
AccuTrack Indicator
Convert Seconds to Trading Bars

How-to Lessons
How to download historical quotes of indices
How to quickly select stocks based on the last value of a databas...
How to dynamically update the settings of an indicator
How to download EOD quotes for active and valid stocks only
How to create a mobile database/account

Related Forum Threads
Using the same data in Amibroker and Quantshare
comp function or equivalent does not seem to be working
Symbol Strength Relative to Index
Exporting optimization results
Market Facilitation Index

Blog Posts
How to create a trading indicator that uses stock news
QuantShare Trading Software: New Features in the 3.3.1 Version
How to Detect Potential Issues/Errors in Your Historical Data?
Backtesting Your Trading Systems: Symbol Segmentation
Backtesting trading strategies using intraday data

Create an account
Affiliate Program
Contact Us
Trading Forum
How-to Lessons
About Us
Terms of Use

Copyright 2023
Social Media
Follow us on Facebook
Twitter Follow us on Twitter
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.