Click here to Login





                                                   Equivalent of an Amibroker Exploration

  0

0
JC
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



QuantShare
2020-09-14 11:35:38

  0

Hi,

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.



JC
2020-09-14 12:13:25

  1

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



QuantShare
2020-09-17 10:29:33

  1

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


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
FII & DII - Foreign and Domestic Institutional Investors
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 plot put/call ratio of individual stocks
How to create histogram charts
How to add a trading indicator to a chart
How to plot the number of stock tweets per day

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









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.