Created
February 24, 2020 13:50
-
-
Save rakeshtembhurne/445287d17ec9b83fe1e273381c0c41ea to your computer and use it in GitHub Desktop.
Extracts daily OI information of NIFTY and BANKNIFTY
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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