Global Script For How To Export In MetaStock Format In Ascii Layout?

Global Script For How To Export In MetaStock Format In Ascii Layout?

Richie Peterson
2023-12-19 02:07:55

Hi

I know this question probably has been asked many times here but the format selected in those questions is not the one required by Metastock Downloader hence this question again!!

Here's the line I changed :

text.AppendLine(sym.Name + ",D," + quotes.Date[j].ToString("mm/dd/yyyy") + "," + quotes.Open[j] + "," + quotes.High[j] + "," + quotes.Low[j] + "," + quotes.Close[j] + "," + quotes.Volume[j] + "," + quotes.OpenInterest[j]);

As Metastock Downloader needs the data to be arranged in this layout of the ascii file

<ticker>, <per>, <date>, <open>, <high>, <low>, <close>, <vol>, <o/i>

I tried changing the order given in earlier answers but every time I tried to import the data base using Metastock Downloader it gives me an error message saying "Invalid File Format"!!

It changes the date format which spoils everything

How can I get this right in the format below?

<ticker>, <per>, <date>, <open>, <high>, <low>, <close>, <vol>, <o/i>

Thanks!!

QuantShare
2023-12-21 02:25:43

.........REMOVED.........

Richie Peterson
2023-12-21 17:05:55

Hi,

I referred to this answer here:

https://www.quantshare.com/title-232-how-to-export-to-metastock-ascii-10-or-11-format

Ive tried both the formats in this answer and MetaStock doesn't accept the file format!!

Metastock Downloader as per downloaders help file needs the data to be arranged in this layout of the ascii file:

<ticker>, <per>, <date>, <open>, <high>, <low>, <close>, <vol>

What to do?

QuantShare
2023-12-22 02:23:06

I don't know why you are getting this error but maybe the data format is not correct or maybe you need to remove the OpenInterest field.

text.AppendLine(sym.Name + ",D," + quotes.Date[j].ToString("mm/dd/yyyy") + "," + quotes.Open[j] + "," + quotes.High[j] + "," + quotes.Low[j] + "," + quotes.Close[j] + "," + quotes.Volume[j]);

Richie Peterson
2023-12-22 17:26:04

Thank You!

I will give this a try this weekend!

Get more messages

No more messages

Back


Trading Items Export Indicators Data - Custom Time Frame Set Global Variable Export Indicators Data with Filtering and Column Labels Support Export Indicators Data Morningstar Annual Fundamentals 2.0 for US and International Stoc...	How-to Lessons How to get stocks for a particular index using the global script How to export trading data to a CSV file How to use QuantShare with Metastock data How to download earnings calendar data for various stocks How to screen for stocks having a high correlation with the Dow J...
Related Forum Threads How to export to metastock ascii, 10 or 11 Format How to export historical data for a list of symbols How to adjust for splits in QS AMM script global variables do not appear to be thread safe Export Aggregate Case Results for Optimization	Blog Posts How to Download Trading Data for Certain Securities Only How to Import Metastock data into QuantShare How to get buy and sell orders for a portfolio based on a trading... Step by step on how to get free realtime/delayed data for stocks,... Charting & Scripts - Manage stock charts using the global script