Changes to Historical Stock Data Macro

Closed Posted Nov 26, 2012 Paid on delivery
Closed Paid on delivery

Changes to Historical Data Workbook for tender…

1. Previously, we wanted all data up until the latest close. Now we would like to be able to choose a start point and end point between which we would like to see data.

Therefore, in the Sheet Data1 near the top by the button please supply drop down boxes for start and end date.

Drop down for DAY, MONTH, YEAR.

End date to default to Todays date.

2. Previously, the error parameters (in point 18 of the previous job spec, attached) were hard coded. We would now like to be able to vary them. Therefore, please can we have a facility to specify the following error parameters. Namely;

a. Drop-box for Minimum number of MONTHS that Historical Data goes back. (1-36)

b. Type-box to set number of days before end-date specified above most recent data must be within (ie if end date is 10-24-12, number of days is set to 10 then if most recent data was from 10-13-12 would fail but if it was 10-14-12 it would be OK).

c. Type-box to set minimum adjusted-close price, to two decimal places.

d. Change the error messages for above to something generic… (e.g. Data does not go back specified time, Below specified price limit or no data within specified time-frame)

3. Make the Workbook 64-bit Excel compatible

4. Change the ”TEST ME” button text to “RUN MACRO”

5. Why does the code: “^DJI” return “File not found” error, followed by “Type Mismatch” error box?

6. When beginning macro run please clear the error messages in row L from previous run.

7. Get rid of the Hyper-Links

8. In the Stock Codes sheet I want to insert a column to the right of CODE called TYPE. The text entered here will then be pasted in Data1 in the column currently designated Open. Therefore headings in Data1 will now be:

‘Record’ ‘Date’ ‘TYPE’ ‘High’ ‘Low’ ‘Close’ ‘Volume’ ‘Adj Close’ ‘CODE’

9. Have a new sheet called “Export”. In this sheet I want to be able to specify a Workbook, Sheet name and starting cell (e.g. A92) and a macro button to copy the Data1 outputs from (currently) A2 to last cell and paste them into the specified location. (Is this possible?).

End

Visual Basic for Apps

Project ID: #3986494

About the project

16 proposals Remote project Active Jan 2, 2013

16 freelancers are bidding on average $113 for this job

salih0vicx

With my great supporters (niece and nephew; c my profile photo) I would like to take care of this micro-simple task. Is it so obvious? Yes, we are new here and therefore we do need our first review. All three of us More

$30 USD in 0 days
(7 Reviews)
4.4
finecodervw

Hi, I am very keen to work on this project. Thanks

$225 USD in 15 days
(10 Reviews)
4.2
diegogarcia0531

Hi, I can do the job, MS Excel Expert, VB6, VBA, VBNET developer for a several years Please check PMB

$100 USD in 3 days
(7 Reviews)
4.1
adim

Lot of experience in this field, please check PM.

$150 USD in 5 days
(4 Reviews)
3.9
Krusche

We offer user friendliness, elegance, even some "smart sexiness" in the approach to cover your business need. Quickness and high quality are implied.

$120 USD in 7 days
(1 Review)
2.4
neel1311991

Very much interested in this project, got a team of 4 engineers, will provide maximum quality for a reasonable cost..

$200 USD in 10 days
(0 Reviews)
0.0
benefitworks

Hi I can do this. Please see my portfolio for similar projects Regards Benefit works

$90 USD in 3 days
(0 Reviews)
0.0
DavidLSander

I am an expert in VBA and excel. I can do this in one day and need another day to test. This is my first project online but I was fully fledged software consultant in the city. You can see my profile on Linked In Da More

$30 USD in 5 days
(0 Reviews)
0.0
ExpertDeveloper5

I have over 5 years experience in MS Office (and .NET) programming experience. I am available to start your project immediately.

$150 USD in 5 days
(0 Reviews)
0.0
mvlp

Hi, Please consider my offer. Check the PMB. Thanks

$140 USD in 5 days
(0 Reviews)
0.0
mknoke

Ready to complete this project on time and within budget with an extremely high level of quality

$200 USD in 3 days
(0 Reviews)
0.0
clafoutis8

Hello, I am an experienced quantitative analyst & software developer in the financial sector with over 15 years of programming in Excel VBA. You will receive a comprehensive robust spreadsheet and, possibly, a few t More

$50 USD in 3 days
(0 Reviews)
0.0
vbexpart

Hire the right one.

$125 USD in 3 days
(0 Reviews)
2.0