Click here to Login





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

  0

0
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

  0

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


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

  0

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

  0

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

  0

Thank You!

I will give this a try this weekend!



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
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 run a screen or a watchlist from a script

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









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 © 2024 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.