Find Jobs
Hire Freelancers

Build stock market pricing spreadsheet(repost)

$100-200 USD

Finalizat
Data postării: peste 19 ani în urmă

$100-200 USD

Plata la predare
The output of this project is a tab-delimited text file (suitable for importing into Excel) containing share price data for all publicly traded stocks that have had recent IPO's (initial public offerings). A template for the output is attached in Excel format, though your output should be tab-delimited text. How you build this database is up to you: it could be constructed from an available share price / company statistics database, or scraped off of publicly available historical stock price data on a website, or otherwise. The output should include: - All companies that have gone public since 1/1/1999. - A complete history of share prices for each one of those companies, from the first day of trading to the present. - Data formatted as a flat file with a header row of labels at top - The following columns: 1) Company name; 2) Ticker symbol; 3) IPO date; 4) Trading date; 5) Day number; 6) High share price on the trading date; 7) Low share price on the trading date; 8) Closing share price on the trading date; 9) Volume of shares traded; 10) Shares outstanding as of the trading date (see below); 11) Indication of any splits and the split ratio. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as .exe or other executable files that require nothing other than Microsoft Office or files distributed with the deliverables to run. 3) Also in your deliverables, you must include the output text data file itself, i.e. the results of running the program, with all data complete through at least 11/8/04. Notes: - All fractional values should be expressed as decimal equivalents (i.e. 56 5/8 should be shown as 56.625) - Day number should indicate "1" for the day the stock began trading (IPO date), "2" for the following calendar day, "3" for the following calendar day, and so on. This means that if a stock debuted on a Wednesday, then the first entries would be numbered 1, 2, 3, 6 (i.e. no 4 and 5 because they were weekend (non-trading) days. - All share price data should be on an adjusted basis -- i.e. adjusted as appropriate for any splits that occured subsequent to the trading date so the "per share" basis will be equivalent to the present "per share" - Would prefer shares outstanding to be a historical value as of the trading date, but if it is not available historically, then a present value is ok. - It is ok to semi-hard-code the list of stocks that the program goes after, i.e. to demand as input to the program a table of stock tickers and ipo dates. However, as part of the deliverable, you must pre-populate such an input with a complete set of all stocks that IPO'd on or after 1/1/99. Please note that the data sources for this are up to the programmer to identify: no other info will be provided other than this spec. ## Platform Windows 2000.
ID-ul proiectului: 3439037

Despre proiect

3 propuneri
Proiect la distanță
Activ: 19 ani în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
Acordat utilizatorului:
Avatarul utilizatorului
See private message.
$127,50 USD în 2 zile
2,0 (6 recenzii)
2,6
2,6
3 freelanceri plasează o ofertă medie de $156 USD pentru proiect
Avatarul utilizatorului
See private message.
$85 USD în 2 zile
5,0 (6 recenzii)
3,5
3,5
Avatarul utilizatorului
See private message.
$255 USD în 2 zile
5,0 (9 recenzii)
2,8
2,8

Despre client

Steagul UNITED STATES
Seattle, United States
5,0
14
Metoda de plată a fost confirmată
Membru din oct. 17, 2004

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.