How do I change the date format?

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.

Thanks,

Graeme

QuantShare
2012-01-30 09:08:06

Best Answer

Hi,

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:
http://www.quantshare.com/title-232-how-to-export-to-metastock-ascii-10-or-11-format

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?

QuantShare
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.

Get more messages

No more messages

Back


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 create market indicators using the composite function - Pa... How to Display the Year-to-Date Excess Return in a Pivot Table How to Use the Percentage Scale