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.


Taidot: tietojenkäsittely, Excel, Visual Basic

Näytä lisää: stock data excel, stock excel file, excel macd stc rsi formula, excel formula macd stc, x on demand, what is profile id, what can i buy and sell for a profit, vba profile, software websites, software open, profile formats, price for vba for excel, pair line, on demand screen, non profit websites, market net, line coding, i.t. positions, hrly, free data input software, free coding websites, excel company profile, construction positions, company software, coding websites free

Tietoa työnantajasta:
( 0 arvostelua ) Lantau, Hong Kong

Projektin tunnus: #513175

15 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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

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

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)

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

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

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

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

send me the file and the added instruction if needed

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

No Details please

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

Please check PM message.

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

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)

I'll do it!

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

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)

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)

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

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

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)

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)

Please check your PM, Regards

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