Đã Đóng

Stock Market Database Queries and Reports

Introduction of Database -

I have got a database in MS-Access in which I import the Stock Market EOD "End of Day" data for NSE "National Stock Exchange of India" Futures Contracts on a daily basis. The database table has got following fields/columns in it -

INSTRUMENT --- whether it is stock future or index future

SYMBOL

EXP_DATE --- expiry date of this contract

OPEN_PRICE

HI_PRICE

LO_PRICE

CLOSE_PRICE

OPEN_INT --- Open Interest of the contract

TRD_VAL --- Traded VALUE of the contract in Rs - Indian Currency

TRD_QTY --- Total number of shares traded - this is same as VOLUME

NO_OF_CONT --- Total number of shares traded converted into number of contracts

NO_OF_TRADE --- Total number of trades

Sector --- Which sector this contract belongs to

Series --- Which series contract it is out of 4

Price % Chg --- % change in price over the previous day

Timestamp --- Date of the trading session

I have attached a small sample of the database as well as a few snapshots to make it completely clear.

Requirement -

Queries and Reports -

I want a few basic queries to be designed for example -

30 Days Average Volume for each stock.

30 Days Total Volume for each stock.

Comparison of current day volume, with the 30 day average volume of the stock.

I want the results to be SECTOR WISE Sorted. Like all the stocks from BANK Sector , OIL Sector etc. should be shown combined. Please look at the snapshots to become more clear about Sector Wise Sorting issue.

Programmer Qualification -

I am looking for some one who has at least very basic understanding about what the stock market is, what is meant by volume of a stock, what is meant by the bank sector etc. So that I do not have to explain these basic things to him.

If the programmer has already worked on any stock market related database in any format, then that would be an added benefit.

This work is very simple and easy, provided you understand my requirement.

More details can be provided in a very step by step manner, once I receive your bid.

Kỹ năng: Quản trị cơ sở dữ liệu

Xem thêm: programmer india price, programmer contracts, national exchange bank, access administration, instrument indian, import administration, contracts administration, contract bank, comparison price programmer, comparison sorting, chg, price comparison india, stock market database, stocks trading, my reports, looking programmer india, timestamp, stock shares, stock market data, stock exchange, queries, market over, indian database, database queries, contract administration

Về Bên Thuê:
( 0 nhận xét ) India

Mã Dự Án: #1625088

3 freelancer đang chào giá trung bình $143 cho công việc này

vaibhavworld89

Can provide your requirements in the earliest time.

$30 USD trong 7 ngày
(0 Đánh Giá)
0.0
M8G0KuzQ2

<b><i>Removed by Admin</i></b> - Custom software development - skpye: <b><i>Removed by Admin</i></b>

$250 USD trong 1 ngày
(0 Đánh Giá)
0.0
atifalimalik

I have more than 5 years of experience in database design and writing complex queries. I am teradata certified Master and can handle such projects with ease. Looking forward to work with you. Thanks, Atif Malik

$150 USD trong 2 ngày
(0 Đánh Giá)
0.0