• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

Need some programming for a project

T

Tweakmeister

[H]ard|Gawd
Joined
Mar 11, 2000
Messages
1,222
As the title states, I'm looking for a programmer for a project I'm working on. I'm a finance major, and am looking for a programmer to create either a spreadsheet or program that can fetch data and then process it (like a screener). This is not for an assignment, more a side project of my own and will pay.

I've got several parameters, and would like to have the program/spreadsheet go out and retrieve data off of feeds (websites).

From a programming perspective I'm still trying to figure out the best way to approach this - any input is appreciated.
 
a good start would be to provide examples of the input data, output data, and the interface
 
http://finance.yahoo.com is a very popular site, but I've found it diificult to import data from their information.

Something like:

-http://quote.morningstar.com/Quote.html?pgid=hetopquote&ticker=hd
-http://moneycentral.msn.com/detail/stock_quote?Symbol=hd

I know with Excel, you can select tables or groups of data off of websites and import it into sheets (it will grab the latest info whenever you update). Something like this may work.
 
what are the parameters? do you just want something where you just provide a symbol, and the script will then fetch that symbol's information from a page and create a spreadsheet from it?

if so, I could probably do it, but only using Perl. to run it on a Windows machine you would need to install ActiveState Perl, and the modules I plan on using might be a pain to install. the only realistic approach I could provide is to create a web application, run off a server with Perl and CGI access, that will ask for the symbol and return the information as a formatted html table. if you require the ability to manipulate it perhaps Excel will be able to make use of the simplified table.

http://finance.yahoo.com/q?s=hd
is this representative of the page you'll be retrieving data from?

the modules I would be using would have to make some very specific assumptions about how the data will be presented on the finance site, if yahoo were to add an additional item, for example, or change the layout of their table, the application would likely break. i could do it for you, but it wouldn't be robust, and to be completely honest I wouldn't feel comfortable charging for such a volatile application.

i think your best bet is to find a site that provides a better interface for accessing this kind of data, parsing HTML is never a good idea. i know for a fact several companies provide a well-defined and usable API for retrieving this type of information for stock tickers and whatnot, i'm just not aware of any off the top of my head.
 
I have a Java program, (I would need to look around for it) that grabs stock prices from yahoo, and save to .csv files. PM me and let me know the details of what you need and I could possibly tweak the code accordingly.
 
bitbum - thanks, it may be useful for this.

I'm working on getting the exact input and output perimeters I'm looking for with this program. I'm also stuck with a nice mid-term this week - will post up specifics shortly.
 
You must log in or register to reply here.
Back
Top