Click here to Login





                                                   Deleting Data From The Database

  0

0
Don Terry
2011-01-02 12:36:35


I found some erroneous data in the database which I can't seem to delete in bulk.
The historical quotes for delisted stocks is loading data for 12/24/2010 and the market was closed.
I tried the delete function in the database editor but it did failed to delete the data.
Any suggestions?

Thanks!



QuantShare
2011-01-03 05:13:15

  0

Yes. Select Data -> Edit Databases then "Manage Databases" tab.

In the "Delete Database Data", select "Quotes", your symbols and the date you want to delete.



Don Terry
2011-01-03 07:32:29

  0

As stated previously, I tried using the delete function in the database editor and that function does not work. I can provide screen shots if it would be helful.

Thank you



QuantShare
2011-01-03 08:52:36

  0

Best Answer
To delete data for 12/24/2010. Select 12/23/2010 as Start Date and 12/24/2010 as End Date.
We will fix this in the next release.



Don Terry
2011-01-03 20:21:07

  0

That worked! Thanks!


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
Lagged Data From a Custom Database
News data for US companies from Google RSS feed
Market cap, ROE, ROA and Forward PE for U.S. Stocks - Fundamental...
How far are the close prices from the support line
Market Cap Historical Data for the US Stock Market

How-to Lessons
How to quickly download the most recent EOD data for your stocks
How to quickly select stocks based on the last value of a databas...
How to import trading data from CSV files
How to automate the data downloading process
How to download a trading item from the Sharing Server

Related Forum Threads
Removing freak data from the database
Plotting the data from custom -Intraday data base
How to view the raw data files?
How to import to database from a csv file?
How to Import data from metstock folder.

Blog Posts
How to filter quotes data from high and low price spikes
Download historical EOD data for the stock, futures, ETF and Fore...
Download Trading Data using the Post-Script
Download Trading Data using the Pre-Script
Create custom metrics for the statistical data analysis tool









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 © 2012 QuantShare.com
Social Media
Follow us on Facebook
Twitter Follow us on Twitter
Google+
Follow us on Google+
RSS Trading Items