Click here to Login





                                                   Data Error Correction

  0

0
ymlee
2015-01-17 12:47:57


Hi,

Can anyone show me a simple data correction script in C# how to replace Open, High, Low with Closing Price if those 3 fields are 0 pricing?
This problem only happen if there is no transaction in daily bar.

It give me ridiculers result when I backtest my short strategy.



QuantShare
2015-01-19 05:53:04

  0

If you are using a downloader, you can add a "pre-script". Example can be found in the "Historical Stock Market Data" downloader.

Here is how to debug/update a downloader:
http://www.quantshare.com/how-431-how-to-debug-a-downloader



ymlee
2015-01-19 10:52:02

  0

I am using Xenith data feed, which direct calling BackfillEOD().

So I want to create a simple script to loop all the symbols and check for 0 value on Open, High & Low and replace it with Close.



QuantShare
2015-01-20 01:47:24

  0

Please contact us by email regarding this.


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
Financial fundamental data for US companies
EOD Data for Forex
Index Investment Data for U.S. Futures Markets
Consumer Credit Historical Data
NYSE Historical Volume Data

How-to Lessons
How to download historical EOD data for penny stocks
How to quickly download the most recent EOD data for your stocks
How to download and use U.S. stocks earnings data
How to export trading data to a CSV file
How to create trading rules based on Put and Call volume data

Related Forum Threads
Error in downloading data
Conversion error importing data
Downloading Mutual fund data
data problem
Scripts to Find Data Errors

Blog Posts
Download Trading Data using the Pre-Script
How to deal with StockTwits data
How to Download Trading Data for Certain Securities Only
Download historical EOD data for the stock, futures, ETF and Fore...
German Stock Exchanges: 5 free ways to download historical EOD/In...









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.