Skip to content

Instantly share code, notes, and snippets.

@rakeshtembhurne
Created February 24, 2020 13:50
Show Gist options
  • Save rakeshtembhurne/445287d17ec9b83fe1e273381c0c41ea to your computer and use it in GitHub Desktop.
Save rakeshtembhurne/445287d17ec9b83fe1e273381c0c41ea to your computer and use it in GitHub Desktop.
Extracts daily OI information of NIFTY and BANKNIFTY
const csv = require("csvtojson");
const _ = require('lodash');
const logD = data => {
console.log(data);
process.exit();
}
const args = process.argv.slice(2);
if (args.length !== 1 || !args[0]) {
logD("Invalid arguments");
}
const csvFilePath = `./${args[0]}`;
csv()
.fromFile(csvFilePath)
.then(json => {
console.log("\n");
const niftyPeOi = _.map( _.filter(json, { SYMBOL: "NIFTY", OPTION_TYP: "PE" }), stock => +stock.OPEN_INT);
const niftyPeCh = _.map( _.filter(json, { SYMBOL: "NIFTY", OPTION_TYP: "PE" }), stock => +stock.CHG_IN_OI);
console.log("NIFTY PE", "OPEN INTEREST", _.sum(niftyPeOi))
console.log("NIFTY PE", "Change in OI", _.sum(niftyPeCh))
console.log("\n");
const niftyCeOi = _.map( _.filter(json, { SYMBOL: "NIFTY", OPTION_TYP: "CE" }), stock => +stock.OPEN_INT);
const niftyCeCh = _.map( _.filter(json, { SYMBOL: "NIFTY", OPTION_TYP: "CE" }), stock => +stock.CHG_IN_OI);
console.log("NIFTY CE", "OPEN INTEREST", _.sum(niftyCeOi))
console.log("NIFTY CE", "Change in OI", _.sum(niftyCeCh))
console.log("\n");
const niftyBankPeOi = _.map( _.filter(json, { SYMBOL: "BANKNIFTY", OPTION_TYP: "PE" }), stock => +stock.OPEN_INT);
const niftyBankPeCh = _.map( _.filter(json, { SYMBOL: "BANKNIFTY", OPTION_TYP: "PE" }), stock => +stock.CHG_IN_OI);
console.log("BANKNIFTY PE", "OPEN INTEREST", _.sum(niftyBankPeOi))
console.log("BANKNIFTY PE", "Change in OI", _.sum(niftyBankPeCh))
console.log("\n");
const niftyBankCeOi = _.map( _.filter(json, { SYMBOL: "BANKNIFTY", OPTION_TYP: "CE" }), stock => +stock.OPEN_INT);
const niftyBankCeCh = _.map( _.filter(json, { SYMBOL: "BANKNIFTY", OPTION_TYP: "CE" }), stock => +stock.CHG_IN_OI);
console.log("BANKNIFTY CE", "OPEN INTEREST", _.sum(niftyBankCeOi))
console.log("BANKNIFTY CE", "Change in OI", _.sum(niftyBankCeCh))
console.log("\n");
});
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment