Deleting an instrument data from mongo

[emretezel]

Hi Everyone,

Is there an easy way to delete all data (contract prices, roll calendars, multiple prices and adjusted prices) for a single instrument? Any helper script?

Best,
Emre

[emretezel]

Turned out to be quite easy to write given nicely designed framework :)

"""
Deletes all contract, multiple and adjusted prices for an instrument.
"""
import sys

from sysdata.arctic.arctic_futures_per_contract_prices import arcticFuturesContractPriceData
from sysdata.arctic.arctic_multiple_prices import arcticFuturesMultiplePricesData
from sysdata.arctic.arctic_adjusted_prices import arcticFuturesAdjustedPricesData

if name == "main":
instrument_code = sys.argv[1]

# Delete contract data
contract_data = arcticFuturesContractPriceData()
contract_data.delete_all_prices_for_instrument_code(instrument_code, areyousure=True)

# Delete multiple price data.
multiplePriceData = arcticFuturesMultiplePricesData()
multiplePriceData.delete_multiple_prices(instrument_code, are_you_sure=True)

# Delete adjusted prices.
adjustedPrices = arcticFuturesAdjustedPricesData()
adjustedPrices.delete_adjusted_prices(instrument_code, are_you_sure=True)

[bug-or-feature]

Handy. Maybe create a module in data/tools?