I have a file in format as
[EMAIL PROTECTED]:~/stock/today$ head -n5 Pd250607.csv
MKT,SERIES,SYMBOL,SECURITY,PREV_CL_PR,OPEN_PRICE,HIGH_PRICE,LOW_PRICE,CLOSE_PRICE,NET_TRDVAL,NET_TRDQTY,IND_SEC,CORP_IND,TRADES,HI_52_WK,LO_52_WK
Y, , ,S&P CNX Nifty, 4252.05, 4251.40, 4264.25,
4236.30, 4259.40, 83083471868.32,295713515,Y,
,3057964, 4362.95, 2878.25
Y, , ,CNX IT, 5159.90, 5165.80, 5167.25, 5084.20,
5110.45,0,0,Y, ,0, 5857.10, 3811.05
Y, , ,CNX Nifty Junior, 8428.75, 8436.50, 8491.30,
8394.10, 8482.45,0,0,Y, ,0, 8491.30, 4735.60
Y, , ,S&P CNX Defty, 3619.15, 3609.65, 3620.60,
3593.60, 3614.05,0,0,Y, ,0, 3733.20, 2125.95
I used a scipt "gethilo" as follows to get highs and lows.
#!/bin/bash
rm -f highs
rm -f lows
IFS=","
while read MKT SERIES SYMBOL SECURITY PREV_CL_PR OPEN_PRICE HIGH_PRICE
LOW_PRICE CLOSE_PRICE NET_TRDVAL NET_TRDQTY IND_SEC CORP_IND TRADES
HI_52_WK LO_52_WK
do
if [[ $SYMBOL == [3,A-Z]* ]]
then
LO_52_WKC=$(echo $LO_52_WK|tr -d "\r")
if [ "$HIGH_PRICE" = "$HI_52_WK" ]
then
echo $SYMBOL >> highs
elif [ "$LOW_PRICE" = "$LO_52_WKC" ]
then
echo $SYMBOL >> lows
fi
fi
done < $1
$1 is previous file.
I get highs and lows.
Now my problem is
1)when I do
for line in $(cat /home/lvgandhi/stock/today/highs); do echo
"$line,14" >> temp;done
I get 14 appended only for the last line.
I would like it to be as
ABB,14
AUROPHARMA,14
2) when I do
for stock in $(cat /home/lvgandhi/stock/today/highs|cut -d, -f1);do ln
-s /home/lvgandhi/.qtstalker/data1/data/Stocks/nse/$stock $stock;done
I get
n: accessing
`ABB\nREL\nAUROPHARMA\nGMRINFRA\nIDFC\nLICHSGFIN\nADLABSFILM\nADVANIHOTR\nANKURDRUGS\nAPIL\nASHAPURMIN\nASIANELEC\nBANCOINDIA\nBBL\nCHETTINAD\nCRISIL\nEASUNREYRL\nEDUCOMP\nENTEGRA\nESABINDIA\nFTCSF3YDIV\nFTCSF3YGRO\nGANESHHOUC\nGBN\nGESHIP\nGMDCLTD\nGREENPLY\nHIKAL\nIBREALEST\nINDIAINFO\nINDOTECH\nJBFIND\nKLGSYSTEL\nMALCO\nNORTHGATE\nNSIL\nOILCOUNTUB\nPAVCI\nPRIMESECU\nROLTA\nRUBYMILLS\nSARLAPOLY\nSATHAISPAT\nSUNDARMFIN\nTHERMAX\nTV-18\nVENKEYS\nVOLTAMP\nOENCONNECT':
File name too long
Any error in my script gethilo? Any correction to get desired result.
--
L.V.Gandhi
http://lvgandhi.tripod.com/
linux user No.205042
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
