Not a very sophisticated spreadsheet.
I enter GFCSI daily values. Then, have a column that tracks percent of current value vs my last trade. Then, total $ of my account, and return to date for the year. Then, I graph the GFCSI daily values vs time. I look at the graph to see visually the peaks and valleys and general trend. Very low tech look; not nearly the sophistication of most of the posters here, that track and name the formations, have different moving averages, etc. But, it has worked for me. I tried to put in a screen shot, but don't have the technology to do so. I'll try pasting a small piece of the spreadsheet in:
[TABLE="width: 1137"]
[TR]
[TD][/TD]
[TD]Sell S[/TD]
[TD]target of [/TD]
[TD]36.8[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]1.392436[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: center"]#VALUE![/TD]
[TD][/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Consider [/TD]
[TD]at [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: center"]#VALUE![/TD]
[TD][/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Sel S[/TD]
[TD]target of[/TD]
[TD]36.5[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]1.381085[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: center"]#VALUE![/TD]
[TD][/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD][/TD]
[TD]That is S&P500 of[/TD]
[TD]2075[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]122.494[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: center"]#VALUE![/TD]
[TD][/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]2092.054795[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]123.5008[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$0[/TD]
[TD][/TD]
[TD="align: right"]-99.99%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]1.014669927[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0.059899[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$0[/TD]
[TD][/TD]
[TD="align: right"]-99.99%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$0[/TD]
[TD][/TD]
[TD="align: right"]-99.99%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$0[/TD]
[TD][/TD]
[TD="align: right"]-99.99%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$0[/TD]
[TD][/TD]
[TD="align: right"]-99.99%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$0[/TD]
[TD][/TD]
[TD="align: right"]-99.99%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$0[/TD]
[TD][/TD]
[TD="align: right"]-99.99%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$0[/TD]
[TD][/TD]
[TD="align: right"]-99.99%[/TD]
[/TR]
[TR]
[TD="align: right"]1/9/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]36.5[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1.036573[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$331,942[/TD]
[TD][/TD]
[TD="align: right"]3.66%[/TD]
[/TR]
[TR]
[TD="align: right"]1/8/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]36.13755491[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1.026279[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$328,646[/TD]
[TD][/TD]
[TD="align: right"]2.63%[/TD]
[/TR]
[TR]
[TD="align: right"]1/7/2015[/TD]
[TD]14.6224[/TD]
[TD]16.9457[/TD]
[TD]26.7443[/TD]
[TD]35.6351[/TD]
[TD]23.4841[/TD]
[TD="align: right"]1.000062[/TD]
[TD="align: right"]1.00036[/TD]
[TD="align: right"]1.011949[/TD]
[TD="align: right"]1.01201[/TD]
[TD="align: right"]1.001954[/TD]
[TD="align: right"]$324,077[/TD]
[TD][/TD]
[TD="align: right"]1.21%[/TD]
[/TR]
[TR]
[TD="align: right"]1/6/2015[/TD]
[TD]14.6215[/TD]
[TD]16.9396[/TD]
[TD]26.4285[/TD]
[TD]35.2122[/TD]
[TD]23.4383[/TD]
[TD="align: right"]1.003397[/TD]
[TD="align: right"]1.016917[/TD]
[TD="align: right"]0.989002[/TD]
[TD="align: right"]0.990336[/TD]
[TD="align: right"]0.950031[/TD]
[TD="align: right"]$320,231[/TD]
[TD]100% S[/TD]
[TD="align: right"]0.01%[/TD]
[/TR]
[TR]
[TD="align: right"]1/6/2015[/TD]
[TD]14.6215[/TD]
[TD]16.9396[/TD]
[TD]26.4285[/TD]
[TD]35.2122[/TD]
[TD]23.4383[/TD]
[TD="align: right"]1.003397[/TD]
[TD="align: right"]1.016917[/TD]
[TD="align: right"]0.989002[/TD]
[TD="align: right"]0.990336[/TD]
[TD="align: right"]0.950031[/TD]
[TD="align: right"]$319,397[/TD]
[TD]Adjusted for contributions[/TD]
[TD="align: right"]0.01%[/TD]
[/TR]
[TR]
[TD="align: right"]1/5/2015[/TD]
[TD]14.6207[/TD]
[TD]16.886[/TD]
[TD]26.6655[/TD]
[TD]35.6585[/TD]
[TD]23.5838[/TD]
[TD="align: right"]1.003342[/TD]
[TD="align: right"]1.013699[/TD]
[TD="align: right"]0.997871[/TD]
[TD="align: right"]1.002888[/TD]
[TD="align: right"]0.955928[/TD]
[TD="align: right"]$319,408[/TD]
[TD][/TD]
[TD="align: right"]0.01%[/TD]
[/TR]
[TR]
[TD="align: right"]1/2/2015[/TD]
[TD]14.6181[/TD]
[TD]16.8315[/TD]
[TD]27.1599[/TD]
[TD]36.2327[/TD]
[TD]24.2173[/TD]
[TD="align: right"]1.003164[/TD]
[TD="align: right"]1.010428[/TD]
[TD="align: right"]1.016372[/TD]
[TD="align: right"]1.019038[/TD]
[TD="align: right"]0.981606[/TD]
[TD="align: right"]$319,412[/TD]
[TD]Adjusted for contributions[/TD]
[TD="align: right"]0.01%[/TD]
[/TR]
[TR]
[TD="align: right"]1/2/2015[/TD]
[TD]14.6181[/TD]
[TD]16.8315[/TD]
[TD]27.1599[/TD]
[TD]36.2327[/TD]
[TD]24.2173[/TD]
[TD="align: right"]1.003164[/TD]
[TD="align: right"]1.010428[/TD]
[TD="align: right"]1.016372[/TD]
[TD="align: right"]1.019038[/TD]
[TD="align: right"]0.981606[/TD]
[TD="align: right"]$316,101[/TD]
[TD][/TD]
[TD="align: right"]10.82%[/TD]
[/TR]
[TR]
[TD="align: right"]12/31/2014[/TD]
[TD]14.6165[/TD]
[TD]16.8017[/TD]
[TD]27.1655[/TD]
[TD]36.2964[/TD]
[TD]24.2183[/TD]
[TD="align: right"]1.003054[/TD]
[TD="align: right"]1.008639[/TD]
[TD="align: right"]1.016582[/TD]
[TD="align: right"]1.020829[/TD]
[TD="align: right"]0.981647[/TD]
[TD="align: right"]$316,066[/TD]
[TD][/TD]
[TD="align: right"]10.81%[/TD]
[/TR]
[/TABLE]
I enter GFCSI daily values. Then, have a column that tracks percent of current value vs my last trade. Then, total $ of my account, and return to date for the year. Then, I graph the GFCSI daily values vs time. I look at the graph to see visually the peaks and valleys and general trend. Very low tech look; not nearly the sophistication of most of the posters here, that track and name the formations, have different moving averages, etc. But, it has worked for me. I tried to put in a screen shot, but don't have the technology to do so. I'll try pasting a small piece of the spreadsheet in:
[TABLE="width: 1137"]
[TR]
[TD][/TD]
[TD]Sell S[/TD]
[TD]target of [/TD]
[TD]36.8[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]1.392436[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: center"]#VALUE![/TD]
[TD][/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Consider [/TD]
[TD]at [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: center"]#VALUE![/TD]
[TD][/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Sel S[/TD]
[TD]target of[/TD]
[TD]36.5[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]1.381085[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: center"]#VALUE![/TD]
[TD][/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD][/TD]
[TD]That is S&P500 of[/TD]
[TD]2075[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]122.494[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: center"]#VALUE![/TD]
[TD][/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]2092.054795[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]123.5008[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$0[/TD]
[TD][/TD]
[TD="align: right"]-99.99%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]1.014669927[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0.059899[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$0[/TD]
[TD][/TD]
[TD="align: right"]-99.99%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$0[/TD]
[TD][/TD]
[TD="align: right"]-99.99%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$0[/TD]
[TD][/TD]
[TD="align: right"]-99.99%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$0[/TD]
[TD][/TD]
[TD="align: right"]-99.99%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$0[/TD]
[TD][/TD]
[TD="align: right"]-99.99%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$0[/TD]
[TD][/TD]
[TD="align: right"]-99.99%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$0[/TD]
[TD][/TD]
[TD="align: right"]-99.99%[/TD]
[/TR]
[TR]
[TD="align: right"]1/9/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]36.5[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1.036573[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$331,942[/TD]
[TD][/TD]
[TD="align: right"]3.66%[/TD]
[/TR]
[TR]
[TD="align: right"]1/8/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]36.13755491[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1.026279[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$328,646[/TD]
[TD][/TD]
[TD="align: right"]2.63%[/TD]
[/TR]
[TR]
[TD="align: right"]1/7/2015[/TD]
[TD]14.6224[/TD]
[TD]16.9457[/TD]
[TD]26.7443[/TD]
[TD]35.6351[/TD]
[TD]23.4841[/TD]
[TD="align: right"]1.000062[/TD]
[TD="align: right"]1.00036[/TD]
[TD="align: right"]1.011949[/TD]
[TD="align: right"]1.01201[/TD]
[TD="align: right"]1.001954[/TD]
[TD="align: right"]$324,077[/TD]
[TD][/TD]
[TD="align: right"]1.21%[/TD]
[/TR]
[TR]
[TD="align: right"]1/6/2015[/TD]
[TD]14.6215[/TD]
[TD]16.9396[/TD]
[TD]26.4285[/TD]
[TD]35.2122[/TD]
[TD]23.4383[/TD]
[TD="align: right"]1.003397[/TD]
[TD="align: right"]1.016917[/TD]
[TD="align: right"]0.989002[/TD]
[TD="align: right"]0.990336[/TD]
[TD="align: right"]0.950031[/TD]
[TD="align: right"]$320,231[/TD]
[TD]100% S[/TD]
[TD="align: right"]0.01%[/TD]
[/TR]
[TR]
[TD="align: right"]1/6/2015[/TD]
[TD]14.6215[/TD]
[TD]16.9396[/TD]
[TD]26.4285[/TD]
[TD]35.2122[/TD]
[TD]23.4383[/TD]
[TD="align: right"]1.003397[/TD]
[TD="align: right"]1.016917[/TD]
[TD="align: right"]0.989002[/TD]
[TD="align: right"]0.990336[/TD]
[TD="align: right"]0.950031[/TD]
[TD="align: right"]$319,397[/TD]
[TD]Adjusted for contributions[/TD]
[TD="align: right"]0.01%[/TD]
[/TR]
[TR]
[TD="align: right"]1/5/2015[/TD]
[TD]14.6207[/TD]
[TD]16.886[/TD]
[TD]26.6655[/TD]
[TD]35.6585[/TD]
[TD]23.5838[/TD]
[TD="align: right"]1.003342[/TD]
[TD="align: right"]1.013699[/TD]
[TD="align: right"]0.997871[/TD]
[TD="align: right"]1.002888[/TD]
[TD="align: right"]0.955928[/TD]
[TD="align: right"]$319,408[/TD]
[TD][/TD]
[TD="align: right"]0.01%[/TD]
[/TR]
[TR]
[TD="align: right"]1/2/2015[/TD]
[TD]14.6181[/TD]
[TD]16.8315[/TD]
[TD]27.1599[/TD]
[TD]36.2327[/TD]
[TD]24.2173[/TD]
[TD="align: right"]1.003164[/TD]
[TD="align: right"]1.010428[/TD]
[TD="align: right"]1.016372[/TD]
[TD="align: right"]1.019038[/TD]
[TD="align: right"]0.981606[/TD]
[TD="align: right"]$319,412[/TD]
[TD]Adjusted for contributions[/TD]
[TD="align: right"]0.01%[/TD]
[/TR]
[TR]
[TD="align: right"]1/2/2015[/TD]
[TD]14.6181[/TD]
[TD]16.8315[/TD]
[TD]27.1599[/TD]
[TD]36.2327[/TD]
[TD]24.2173[/TD]
[TD="align: right"]1.003164[/TD]
[TD="align: right"]1.010428[/TD]
[TD="align: right"]1.016372[/TD]
[TD="align: right"]1.019038[/TD]
[TD="align: right"]0.981606[/TD]
[TD="align: right"]$316,101[/TD]
[TD][/TD]
[TD="align: right"]10.82%[/TD]
[/TR]
[TR]
[TD="align: right"]12/31/2014[/TD]
[TD]14.6165[/TD]
[TD]16.8017[/TD]
[TD]27.1655[/TD]
[TD]36.2964[/TD]
[TD]24.2183[/TD]
[TD="align: right"]1.003054[/TD]
[TD="align: right"]1.008639[/TD]
[TD="align: right"]1.016582[/TD]
[TD="align: right"]1.020829[/TD]
[TD="align: right"]0.981647[/TD]
[TD="align: right"]$316,066[/TD]
[TD][/TD]
[TD="align: right"]10.81%[/TD]
[/TR]
[/TABLE]