logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
slipstream  
#1 Posted : Friday, January 11, 2013 4:19:46 AM(UTC)
slipstream

Rank: Member

Groups: Registered, Registered Users
Joined: 2/15/2010(UTC)
Posts: 14

Hi,

I am trialing a different data provider and have downloaded EOD data for the Australian Stock Exchange. The downloaded data is in Metastock format and generally looks ok, but the public holidays have not been removed. This results in a bar with zero volume and Open, High, Low, Close values all equal.

The "Show Empty Holidays" check box under Chart Options has no effect and I don't want to have to go through each stock in the Downloader and remove these zero bars.

Is there a solution; e.g. script or other, that I can take advantage of to rid myself of this problem as these days have an impact on my system results.

Thanks,

Slipstream
wabbit  
#2 Posted : Friday, January 11, 2013 5:21:27 AM(UTC)
wabbit

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia

Was thanked: 16 time(s) in 16 post(s)
Try http://www.premiumdata.net/excellent, quality data. wabbit [:D]
slipstream  
#3 Posted : Friday, January 11, 2013 7:10:44 AM(UTC)
slipstream

Rank: Member

Groups: Registered, Registered Users
Joined: 2/15/2010(UTC)
Posts: 14

Yes, have used them for years for AUS and US data, but would like to try other exchanges which aren't on offer.

Slipstream
slipstream  
#4 Posted : Saturday, January 12, 2013 12:20:02 PM(UTC)
slipstream

Rank: Member

Groups: Registered, Registered Users
Joined: 2/15/2010(UTC)
Posts: 14

Is there a formula in MS that can identify and exclude bars with zero values when calculating indicator values; e.g. zero volume for public holidays?
wabbit  
#5 Posted : Saturday, January 12, 2013 9:36:47 PM(UTC)
wabbit

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia

Was thanked: 16 time(s) in 16 post(s)
You COULD rebuild all the MS indicators from scratch (with some exceptions) but it's still going to be easier to get a better data set in the first place. You could write a script with the MDK to go through and remove the zero volume bars, but then you'd need to purchase something like MetaLib to be able to write the data back to the file as Equis stopped distributing the read/write version of the MDK many years ago.


wabbit [:D]

haddison  
#6 Posted : Monday, January 14, 2013 12:15:25 PM(UTC)
haddison

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 3/6/2010(UTC)
Posts: 113
Location: London

I don't know if you have programming experience, but if you do, you could try MFLib to read and write Metastock data files:

http://forum.equis.com/forums/permalink/34508/35351/ShowThread.aspx#35351

This does work with Intraday data by the way, even though I said in the post above I couldn't get it to work, I did eventually.

It can be downloaded from here:

http://sourceforge.net/projects/meta-all/files/

Even if you don't have programming experience, you could ask someone who has, to do it for you. I personally use it in my programs.
wabbit  
#7 Posted : Monday, January 14, 2013 5:02:01 PM(UTC)
wabbit

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia

Was thanked: 16 time(s) in 16 post(s)
Without digging through my archives of notes etc... If I remember correctly (I rarely do these days!) MFLib doesn't have methods to delete data in existing MS data files? Only to update and add?

I could be wrong about this?



wabbit [:D]
haddison  
#8 Posted : Monday, January 14, 2013 5:29:25 PM(UTC)
haddison

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 3/6/2010(UTC)
Posts: 113
Location: London

Hi Wabbit,

I just checked the PDF documentation. You can only delete the whole security file rather than individual bars, so yes you are right.

I suppose the only way that I know of would be to have two sets of data, the original and the new without the holiday bars, although not ideal.
Sam karan121  
#9 Posted : Tuesday, October 20, 2020 3:06:52 PM(UTC)
Sam karan121

Rank: Newbie

Groups: Registered, Registered Users, Subscribers
Joined: 4/20/2020(UTC)
Posts: 6
Location: Delhi

i want to remove 0 bars from my custom indicator  you can check by this link https://ibb.co/d0cbbfG

Users browsing this topic
Guest (Hidden)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.