View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Garner Frank Garner is offline
external usenet poster
 
Posts: 4
Default Need help with a stock spreadsheet

On Tuesday, January 6, 2015 3:48:01 PM UTC-5, Frank Garner wrote:
I was giving this spread sheet some time ago. The guy that gave it to me said that it has a 90% success rate on test but since then most of the other programs that was needed to get the data from has since quit working. I would like someone to help me get it working and then help to test it and see if it really works or not. Maybe put it all in a windows base program and run it all.
I do not know how to program.


here are some comments when we chatted online which I hope will encourage you to help me on this

This particular spreadsheet is basically tracking low float stocks that are up big at the open

i'll tell you that it all just looks like numbers until you realize the power of what the spreadsheet is really doing for you...
you simply put in a new stock symbol and by 10 a.m., you have enough data to predict how that stock will perform throughout the day..
the EV is the expected value for that stock, based on the first 15 minutes of data

=IF((Y4*X4)<10%,-11.792*(X4*Y4)^2+6.6641*(X4*Y4)-0.1903,0.0033*LN(Y4*X4)+0.3438)


This program does not work no more
to add your own stocks to track.. you basically go onto Quotelogger and download the stock you are interested in..
then open an entirely new excel spreadsheet, go to Data-Import external data-Import data..
and browse to the Quotelogger text file..