Excel

K

kwancy

I will like to ask how I can export , open, high, low, close, volume...etc to excel on a universe of stocks without doing them individually. I got this link from e-signal.

http://www.mechtrading.com/qcollector/esignal/index.htm

which costs a one-time fee of $80.00, but a friend of mine told me I can set up a hyperlink using MSN money/yahoo finance for the update, any of you guys know how?

http://www.eoddata.com/

is also a good source but I do not want all of them listed on an exchange. what do you guys will suggest?

thanks
 
Quote from kwancy:

I will like to ask how I can export , open, high, low, close, volume...etc to excel on a universe of stocks without doing them individually. I got this link from e-signal.

http://www.mechtrading.com/qcollector/esignal/index.htm

which costs a one-time fee of $80.00, but a friend of mine told me I can set up a hyperlink using MSN money/yahoo finance for the update, any of you guys know how?

http://www.eoddata.com/

is also a good source but I do not want all of them listed on an exchange. what do you guys will suggest?

thanks
More...

It will be far easier for you to write a plugin for Excel in any of the .NET languages than to wrestle with Excel itself.

See:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_vsto2003_ta/html/ExcelObj.asp

And this for an example in C#:
http://www.c-sharpcorner.com/Code/2003/May/Excel2003fromCSharp.asp

Very flexible; import data from whatever you like.

-segv
 
If you have a little talent with excel and vba it can be done easily. I recall years ago writing some excel vba that downloaded historical daily data from yahoo and inserted it into an access db.
I probably had a list of stocks in excel to process and looped through them creating a web query. I then parsed the data to extract the high,low, close for each day. There is no need for an addin.

However if you want a more elegant solution you can create a .net addin (or use another language, such as java, to do the same thing) that opens up an http stream and reads and parses the yahoo csv file.

The end results will be the same.
 
too hard for me, I do not have programming background as I studied life science at University. Give me the weekend to go over my excel bible and the links. I took a glimpse but already found the first link too hard to understand for me.

I appreciate all the help offered

thanks
 
Too hard for me too. I don't know how to program computers. I know excel, but I don't know C programming or Visual basic programming. I dont' know excel programming. I just know how to use excel. The basics.
 
Quote from kwancy:

too hard for me, I do not have programming background as I studied life science at University. Give me the weekend to go over my excel bible and the links. I took a glimpse but already found the first link too hard to understand for me.

I appreciate all the help offered

thanks
More...

Well then - get to your local community college and load up on their introductory programming classes. You will be programming in a week, and in two months you will thank me. These new languages (C#, Java, Visual Basic) are a walk in the park. So, get to it. There is no good excuse.

-segv
 
Quote from segv:

Well then - get to your local community college and load up on their introductory programming classes. You will be programming in a week, and in two months you will thank me. These new languages (C#, Java, Visual Basic) are a walk in the park. So, get to it. There is no good excuse.

-segv
More...

LOL. Thanks. :D
 
You must log in or register to reply here.
Back
Top