Click here to Login

                                                   How do I change the date format?


Graeme Smith
2012-01-30 04:59:12

For some reason if I examine or export a data series from QS it uses the D/M/YYYY format instead of the US M/D/YYYY format.
Although I am currently testing QS while in Australia (which uses the D/M format), my laptop is set to use the US Date format,
meaning if I try to import into excel or anything else it won't recognise dates such as 28/1/2012.



2012-01-30 09:08:06


Best Answer

You can use the global script (Tools -> Script Editor) to change the date format then export data.

Here you can find a script that exports all your database data to a folder in your hard drive:

Just replace "dd/MM/yyyy" with "MM/dd/yyyy"

Graeme Smith
2012-02-03 08:38:48


I haven't had time yet to really explore QuantTrade yet, I have been to busy, but from what I've seen so far I'm really looking forward to getting to use some of its features. I'm especially impressed by the collective sharing idea, it is really what sets Quant Share apart from anything else. Instead of each person having to invent the wheel (or a download script) themselves, once one person has created it, everyone can benefit. Once I get my head around Quant Share I'll do what I can to add to the community common.

In the meantime, I have a question, related to your post above about exporting data from Quant Serve. I have a number of highly developed systems I have written using c#, SQL server. I would like to integrate those systems with QuantServe / QuantServe with those systems. Is it possible to directly access the QuantServe databases programmatically rather than having to export the data and reimported into my own systems?

2012-02-03 09:27:33


Thank you Graeme.

QuantShare databases are highly compressed and cannot be used outside the application. You have to develop your systems using the trading system editor of QuantShare. Let me know if you need any help with the implementation.

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
Vary the Start Date of a Trading System Simulation
Year to Date Change Indicator
How far are the close prices from the support line
Top 20 stocks with the highest 10 day rate of change - Current an...
Derivatives: Number of days until the expiration date

How-to Lessons
How to dynamically change the number of positions in a portfolio?
How to change volume bar colors when the price closes down
How to dynamically update the settings of an indicator
How to plot the relative performance of several stocks/indices
How to quickly download the most recent EOD data for your stocks

Related Forum Threads
How do you sort simulations by the date that the simulation was r...
how to add buy condition when the color change
How to change the quantshare login in to other PC?
How do I get the date of the current bar in a custom function?
How to get the last day of the month in C#

Blog Posts
How to download the history of dividend payments for stocks in th...
Fundamental analysis: How to track economic indicators in the For...
How to Use the Percentage Scale
How to Display the Year-to-Date Excess Return in a Pivot Table
How to use QuantShare Indicators in the Grid Tool

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

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