Need help with a stock spreadsheet

[Frank Garner]

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 seeif 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.

 

[Frank Garner]

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 areup 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..

 

[dguillett]

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.

I don't know what quotelogger is but have extensive with web scalping so send your file direct to dguillett @gmail.com and I'll take a look.

Describe your process step by step so I will know the logic of what you do
Also, tell me what info you previously got from quotelogger. maybe it can be retrieved elsewhere

 

[Frank Garner]

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.

I sent an email to you and I think I have found another program to use
http://investexcel.net/wp-content/uploads/2014/07/Realtime-Intraday-Stock-Quotes.zip

not sure if it will work for what is needed but what I need is to get stockdata intraday I think is what it is called. The stocks I choose I must be able to get the history of the trades plus the history of what it does for the next hour in delay realtime.

Right now I am waiting on you to reply to my email.

 

[dguillett]

I sent an email to you and I think I have found another program to use
http://investexcel.net/wp-content/uploads/2014/07/Realtime-Intraday-Stock-Quotes.zip

not sure if it will work for what is needed but what I need is to get stock data intraday I think is what it is called. The stocks I choose I must be able to get the history of the trades plus the history of what it does for the next hour in delay realtime.

Right now I am waiting on you to reply to my email.

I did not get a personal email from you but did take a look at Samir's and if it does what you want, use it. Could be improved.

 

[Frank Garner]

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.

I had sent an email to you by this email
dguillett at gmail

but if you did not get it then send me an email at fmgarner on am on yahoo

 

[dguillett]

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.

I don't understand your addy. Try again or re-send to me. Try dguillett1 atgmail.com