Visual Basic Macro Download Data from Yahoo

$30-250 USD

Anulat

Data postării:

peste 13 ani în urmă

$30-250 USD

Plata la predare

I need a macro that downloads historical stock data, copies and pastes the data in separate sheets in excel. My old program is not working in windows 7 with office 2010, so it must be recoded. I have win 7 and office 2010. ONLY SERIOUS BIDS. Only bid if you can attach a demo using my data or one that you have worked on previously with stock data. An example of what i am looking for is at: [login to view URL] the "AnalyzerXL Package" . This is a free download. I am looking for serious bids only and YOU MUST attach a demo. 1. Macro picks symbol from "Input sheet" - gets data from yahoo. "open" "high" "low" "close" and "Volume" (ONLY INFO) 2. Dumps into "HistPrices sheet" and "Calculations sheet" to where formulas generate "BUY", SELL" or "HOLD" signals. 3. Info from Histprices sheet is dumped into "Results Sheet" 4. The "Errorsheet" is in case of a wrong symbol or missing data. If these are populated with data, the results should flow into the other sheets. First Milestone Complete the macros in Excel 2010 Second Milestone Demonstrate that the macros work in Excel 2010 using 7,000 symbols Third Milestone Debugg, fix any errors, work set up volume and closing price chart

ID-ul proiectului: 845964

Despre proiect

5 propuneri

Proiect la distanță

Activ: 13 ani în urmă

Vrei să câștigi bani?

Adresa de e-mail

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

5 freelanceri plasează o ofertă medie de $190 USD pentru proiect

@mrbrave

Ready to start now..

$180 USD în 4 zile

5,0

(72 recenzii)

5,4

@vbexcel

Over ten years experience in developing Excel/VBA solutions including web scraping.

$150 USD în 3 zile

4,9

(26 recenzii)

5,3

@marcuslewis

Please see PM

$250 USD în 1 zi

2,6

(2 recenzii)

4,2

@cau83

Hello, I am attaching 2 things via the Project Board. First, a screenshot that shows I have Excel 2010 and Windows 7. Also, know that the Web-scraper I have is for IE as well. Second, the workbook that I use to track my investments. I am an economics grad student and am taking a break from studying for a big test on Tuesday, so I didn't want to take the time to strip it out-- you obviously are more of a day trader and I have no worry about you seeing the information there. But I do think that the most attractive part about my bid is that I understand what you want from personal experience. I am certainly not as experienced in programming as others who will bid. My bid of $120 is based on an estimate of 6 hours at $20 per hour. I have the web-scraping bit, and a document that updates formulas automatically, which proves I'm capable of doing the job. The part that will take me awhile will be the "errors" sheet. The second part will be taking what I have, and making it in the form you want so that it all runs at one time. Currently mine is in pieces as that suits me just fine since I only use it periodically. Brief explanation of the StockTracker: 'Updater'- test web-scraping for any historical date of your choice. 'Today's Prices'- Automatically get S&P 500 most recent close 'ROTH Summary'- If you check this page before and after you run the Today's price update, you'll see that the Change v S&P 500 changes, showing that info pulled from the web is fed into Excel formulas. Let me know if you have any questions about the bid. I would enjoy this project, be able to learn, and think I can do a good job for you.

$120 USD în 7 zile

5,0

(1 recenzie)

1,4

@Stephen520

I have all the pieces you need for this project. I have developed a StockTicker application with the Yahoo Finance stock data feed in the form of a WindowsClient using the .NET frameworks (VB.NET). I have also developed an Excel Ribbon Add-In that pulls data from a data source and loads it to a spreadsheet. I used Visual Studio Tools for office to accomplish this.

$250 USD în 5 zile