[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: [amibroker] Help - Change quotation value if 0 to previous value



PureBytes Links

Trading Reference Links

I was thinking about looking at the problem from a different angle. This seems to have solved the problem without going through and changing quotes.

 

PE = Foreign( Name()+"-F","Close");

 

PE1 = ValueWhen(PE!=0,PE,1);

Plot(PE1,"Price Earnings Ratio", colorBlue,styleLine );

 

Regards

 

Dave

 

 


From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of dpweir
Sent: Wednesday, 14 September 2005 9:53 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: RE: [amibroker] Help - Change quotation value if 0 to previous value

 

Thanks for your reply Thomas. 

 

I thought that might work as well, but the values still came up as 0 … am I missing something ? Should this have worked ?

 

Best regards

 

Dave

 

 


From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of ThomasZ
Sent: Wednesday, 14 September 2005 9:16 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: Re: [amibroker] Help - Change quotation value if 0 to previous value

 

Hello Dave,

i don't know the details about your csv file, but as you would like to remove the zero columns you could simply use
a standard text editior and Search & Replace.
So maybe search for ,0,
and replace it to ,,
You could replace all results in a few seconds automatically.

Regards
 
Thomas
http://www.tradingbasis.com



dpweir wrote:

Hello

 

I have imported a few csv files as pseudo symbols containing fundamental information using <name>-F for the name.

 

I realise now that the csv files contains a 0 value if no information is available for that date.

 

I was wondering if someone would be able to provide me with a script to go through each symbol with a –F extension, and change any 0 value quotation, to the prior quotation value ?

 

Much appreciate any help. Cheers.

 

Best regards

 

Dave

 

 

 


 





Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com

For other support material please check also:
http://www.amibroker.com/support.html





SPONSORED LINKS
Investment management software Real estate investment software Investment property software
Software support Real estate investment analysis software Investment software


YAHOO! GROUPS LINKS