diff options
Diffstat (limited to 'screener.js')
-rw-r--r-- | screener.js | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/screener.js b/screener.js index f607476..68f1138 100644 --- a/screener.js +++ b/screener.js @@ -175,7 +175,7 @@ const formatDataFromHistories = (histories) => { const mappedValues = { Ticker: symbol, - Name: name.replace(',', ' '), // replace commas in name with spaces for CSV + Name: name, '% Weight': weight, 'Sector': sectorMap[symbol] ? sectorMap[symbol][0] : 'Unknown', 'Subsector': sectorMap[symbol] ? sectorMap[symbol][1] : 'Unknown', @@ -192,12 +192,12 @@ const formatDataFromHistories = (histories) => { }); // write the formatted data to a CSV file - const csvContent = csv_final.map(e => e.join(',')).join('\n'); - if (fs.existsSync('sp500_formatted_data.csv')) { - fs.unlinkSync('sp500_formatted_data.csv'); + const csvContent = csv_final.map(e => e.join('\t')).join('\n'); + if (fs.existsSync('sp500_formatted_data.tsv')) { + fs.unlinkSync('sp500_formatted_data.tsv'); } - fs.writeFileSync('sp500_formatted_data.csv', csvContent); - console.log('Formatted data saved to sp500_formatted_data.csv'); + fs.writeFileSync('sp500_formatted_data.tsv', csvContent); + console.log('Formatted data saved to sp500_formatted_data.tsv'); return csv_final; }; // testGetHistories(); |