Project Detail

Personalized Stock Market Software

Personalized Stock Market Software is project number 513175
posted at GetAFreelancer.com. Click here to post your own project.

| More

Status: Frozen
(Bid period finished)

Selected Providers: -

Budget: $250-750

Created: 09/22/2009 at 20:48 EDT

Bid Count: 15

Average Bid:
$ 581

11/21/2009 at 20:48 EST

Project Creator: hftsang
Employer Rating: (No Feedback Yet)

Description

I have an existing excel file that records historical stock transactions and related statistical data from stock market with DDE function supported. I’d like to enhance it by automation to minimize manual input. VBA or even simpler methods are appreciated, as long as the requirement can be fulfilled.
Basically, my proposed upgrade will include the following:
1) Bulk data update
My excel should be able to feed in daily transactions (no of entries varies everyday) and calculate the net gain/loss for each pair of settled transactions. Related data such as transaction ID, admin fees, etc can be parameter driven to avoid hard-coding (the net gain/loss formula is already present). Please note that the excel should be able to handle overnight transactions (i.e. buy/sell of the transaction are on different bulk files.) The records are separated by month and by sheets in the excel. Monthly sheet can be generated automatically so that the sheet copy step can even be saved.
2) Scrap free real time information from some financial websites (mainly text. Appreciated if non-text figures can be drawn)
3) Decode common csv files from the exchange company (all data formats would be given) and select some of the data to fill in my excel (very straightforward, like taking the closed price of a certain investment product)
4) Automatically update net open positions of investment products traded in (1) and quote daily close price to estimate unrealized profit/loss.
5) Simple alert function – change the color of the real time data like stock price or even offer sound effect when preset price is reached.
6) Using the DDE real time data feed, construct the following common technical indicators: RSI, MACD, STC, SAR, BB, BB bandwidth, %B. The time period of the technical indicators can be parameter driven, like 1-min/5-min/15-min/hrly/daily/weekly/monthly.
7) Automatic plotting of simple x/y-axis line chart of a set of data
8) More advanced functions using DDE: option screen with delta, gamma, vega, theta and implied volatility (IV).
9) Construction of Market Profile using DDE functions
For (8) and (9), it’s more advanced. Total or partial completion of (1) to (7) is also acceptable.
More detailed comments are provided in the attached excel.
To reiterate, the program needn’t be fancy but accuracy is what I demand most.
Thanks.

Additional files submitted:
Sample(22Sep09).xls

Report Violation

Messages Posted:6

If you are the project creator or one of the bidders Log In for more options

PMB

750

15 days

09-22-2009 23:53 EDT

(No Feedback Yet)

I can provide the solution. I've good knowledge in stock market applications Thanks, John

mlov83

600

7 days

09-23-2009 01:47 EDT

(No Feedback Yet)

Hello im an accountant/ programmer i can get this done for you accurately. Please check PM. Thanks

ashishresume

500

30 days

09-23-2009 05:45 EDT

(No Feedback Yet)

Hi, We can definately do this.Previoulsy worked on financial portals. Thanks Ashish

cityworkers

500

10 days

09-27-2009 00:15 EDT

(No Feedback Yet)

Hello I have experience on providing finacial applications, please check PM, thanks Dennis

milagrosmorre

500

20 days

09-27-2009 09:45 EDT

(No Feedback Yet)

send me the file and the added instruction if needed

Stan4God

865

21 days

10-02-2009 08:14 EDT

(No Feedback Yet)

No Details please

moktarulbd

500

3 days

10-07-2009 02:24 EDT

(No Feedback Yet)

Please check PM message.

unlimited198

450

2 days

11-01-2009 23:59 EST

(No Feedback Yet)

i promise u ll like my work plz select me for this project.. plz refer my PM.

lupuna

700

7 days

10-20-2009 12:20 EDT

(No Feedback Yet)

I'll do it!

skmalviya1979

700

30 days

10-31-2009 12:55 EDT

(No Feedback Yet)

Dear Sir, We are a team of developers especially in .NET/C# and SQL Server/Oracle. We would do it with C# and the database part with either SQL/Oracle Server. For any queries concerning your way of seeing this project done we are at your disposal. Our Company’s team of web developers is ready to work on this project. Please provide more details on what the project is. Please check PM. Best Regards. Ultiwork Tech Development, Inc.

mwhoward

500

14 days

11-01-2009 12:25 EST

(No Feedback Yet)

There are many simple solutions that can be implemented to fit your specs, and I specialize in data updating automation in excel.

bntgupta47

450

20 days

11-02-2009 23:30 EST

(No Feedback Yet)

Please Open the chat session foe getting the more detail of project

tecanalyzer

700

10 days

11-04-2009 22:32 EST

(No Feedback Yet)

Hi, I am an MBA - Finance graduate with 4 years of work experiece in stock market and hands on advanced Excel and VBA. I can get this done for you. Please provide me the files you receive from to be uploaded automaticaly(where you need to avoid manual data entry). I didnt understand anything from the pdf attachement. Needed some clarification on that. Please let me know your comments. Regards TecAnalyzer.

iitmhimanshu

250

10 days

11-09-2009 17:28 EST

(No Feedback Yet)

Hi, I have core expertise in excel, VBA and data processing. On demand, I can send you the first rough draft to judge the performance. This can be made automatic with refresh of data after fixed time interval, which will provide time frame analysis of stocks. Based on selection of a stock / portfolio (User will have flexibility create /delete portfolios) user can monitor stock / portfolio trend for selected time-period (appearance wise it can be make similar to stock charts at rediff.com). At the end of the day or till particular time period one can view top gainer / top loser. This tool will also provide the option to create market profile using DDE functions. I would prefer to use Office 2007 due to its capability to handle more data than Office 2003. However, based on client's requirement I can proceed in Office 2003. Regards Himanshu

infotech017

750

0 days

11-09-2009 20:46 EST

(No Feedback Yet)

Please check your PM, Regards

Bid on this Project

WHAT IS FREELANCER.COM?

Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.