Deleting Quote data for a symbol from the Database

Deleting Quote data for a symbol from the Database

Dev
2018-11-27 16:58:32

How can I delete quote data for a symbol (either all data or some data for a particular date) in a C# script rather than manually. Thanks

QuantShare
2018-11-29 02:51:41

Here is how: (Same logic applies to intraday data - Quotes.GetIntradayQuotes)

HistoricalQuotes hq = Quotes.GetHistoricalQuotes("AAPL");
MessageBox.Show(hq.Date.Length.ToString());
hq.Date = new DateTime[0];
hq.Close = new double[0];
hq.Open = new double[0];
hq.High = new double[0];
hq.Low = new double[0];
hq.Volume = new double[0];
hq.OpenInterest = new double[0];
Quotes.SaveHistoricalQuotes(hq);

QuantShare
2018-11-29 11:25:06

Please remove this line:
MessageBox.Show(hq.Date.Length.ToString());

Get more messages

No more messages

Back


Trading Items News data for US companies from Google RSS feed Lagged Data From a Custom Database Market cap, ROE, ROA and Forward PE for U.S. Stocks - Fundamental... Market Cap Historical Data for the US Stock Market Historical EOD data Downloader for Delisted/Bankrupt Stocks	How-to Lessons How to quickly download the most recent EOD data for your stocks How to import trading data from CSV files How to download earnings calendar data for various stocks How to quickly select stocks based on the last value of a databas... How to get fundamental data for U.S. Stocks
Related Forum Threads Deleting Data From The Database Removing freak data from the database Plotting the data from custom -Intraday data base What is the stock symbol for India VIX? Continuous futures symbol for Live data feed Interactive Broker	Blog Posts Create custom metrics for the statistical data analysis tool 6 New Ways to Download Free Intraday Data for the U.S. Stock Mark... Download historical EOD data for the stock, futures, ETF and Fore... 6 ways to download free intraday and tick data for the U.S. stock... How to filter quotes data from high and low price spikes