Suljettu

Personalized Stock Market Software

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.

Taidot: tietojenkäsittely, Excel, Visual Basic

Näytä lisää: stock data excel, stock excel file, excel formula macd stc, vba profile, software websites, software open, profile formats, pair line, demand screen, non profit websites, market net, line coding, hrly, free data input software, free coding websites, excel company profile, construction positions, company software, coding websites free, bb t, automatic data processing, update stock data everyday, stock chart, open gamma, i market

About the Employer:
( 0 reviews ) Lantau, Hong Kong

Projektin tunnus: #513175

15 freelanceria on tarjonnut keskimäärin 581 $ tähän työhön

BSoftTech

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

750 $ USD 15 päivässä
(1 arvostelu)
2.4
mlov83

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

600 $ USD 7 päivässä
(1 arvostelu)
1.0
ashishresume

Hi, We can definately do [url removed, login to view] worked on financial portals. Thanks Ashish

500 $ USD 30 päivässä
(0 arvostelua)
0.0
cityworkers

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

500 $ USD 10 päivässä
(0 arvostelua)
0.0
milagrosmorre

send me the file and the added instruction if needed

500 $ USD 20 päivässä
(0 arvostelua)
0.0
Stan4God

No Details please

865 $ USD 21 päivässä
(0 arvostelua)
0.0
moktarulbd

Please check PM message.

500 $ USD 3 päivässä
(0 arvostelua)
0.0
unlimited198

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

450 $ USD 2 päivässä
(0 arvostelua)
0.0
lupuna

I'll do it!

700 $ USD 7 päivässä
(0 arvostelua)
0.0
skmalviya1979

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 proj Lisää

700 $ USD 30 päivässä
(0 arvostelua)
0.0
mwhoward

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

500 $ USD 14 päivässä
(0 arvostelua)
0.0
bntgupta47

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

450 $ USD 20 päivässä
(0 arvostelua)
0.0
tecanalyzer

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 Lisää

700 $ USD 10 päivässä
(0 arvostelua)
0.0
iitmhimanshu

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, w Lisää

250 $ USD 10 päivässä
(0 arvostelua)
0.0
infotech017

Please check your PM, Regards

750 $ USD 0 päivässä
(0 arvostelua)
0.0