Click here to Login

                                                   First time here. Questions about Excel and Quantshare


2015-03-07 12:56:07

I have just joined this great community, hoping to contribute some of my years of real world trading experiences with the group.

I have not purchased the Quantshare software, but have heard a lot of good things about it from my friends.

I have a couple of questions:

1. I have personally developed a tons of market "breadth"-based indicators in Excel Formulas and/or VBA
(such as Sector-based, Index-based, Industry-group-based breadth indicators)
I would like to know how easy is it to convert from the Excel-based Breadth-indicators to Quantshare custom composite indicators.
I already see some of the breadth-based indicator available in Quanshare, such as TRIN, ADV-DEC line, etc.

2. The problem of Excel is that I have to develop my own symbol/quote database in MS Access and then import into Excel.
But my database is getting so huge, My Excel can't handle the data any longer.
So, I would like to ask the experts here, how easy is it for me to import my huge Access database into Quantshare and do the analysis with my own custom breadth-based indicators.

3. When doing the Breadth based analysis, the CPU demand is immense, Is there a performance problem with QUantshare system?


2015-03-09 03:33:03



1/ It is not difficult to create custom breadth indicators. We have many example in the sharing server.
2/ You should export your Access data in CSV format then import it into QuantShare. Or you can use one of our downloaders to get data into QuantShare
3/ QuantShare performance is much better than Excel. Everything is done in background and you will be informed when market breadth calculation is completed.

2015-03-12 12:58:41


Thanks for the great and prompt responses from the Quantshare support team through several private customer support email exchanges. I am totally convinced that this is the right product for me to convert my massive MS Access databases into Quantshare databases. Great product with flexible and powerful language supports!!!

I just have to sat thanks again to the great support team for their patience and knowledge. Keep up the good work.

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
Equity and Date Export To Excel
High and Low Between a Start and End Time
Trading Indicator: True between the first and last signal
Research and Development Percentage - US Stocks
5-Minute Historical Intraday Data for Forex, Indices and Futures/...

How-to Lessons
How to create and trade a Neural Network model
How to use QuantShare with Metastock data
How to hide a trading indicator from a particular time frame
How to detect stocks trading near all time highs
How to download and use U.S. stocks earnings data

Related Forum Threads
Questions and Code to Share: Weekly Expected Move (IV)
about scaners and fliters
Visible Date of first and last bar on chart
Send Symbol from Excel cell to active Quantshare chart window
Quantshare release notes and in the works

Blog Posts
Reading and Exporting Data from QuantShare to Excel Programmatica...
How to Send Commands to QuantShare from Excel or Other Applicatio...
3 Items To Get and Trade the News In QuantShare Platform
More about QuantShare Programming Language
Different periodicities and chart bar types in QuantShare Trading...

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

Copyright 2021
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.