Stock Quote Function in Excel

Budget $30 - $100 USD
Bids 11
Average Bid $88

Wanted: a function that returns the value of the last trade price for that stock given a stock symbol . This function should be available in Excel. I'd prefer the function be available via an add-in so that I can call it from various spreadsheets easily. You can assume an internet connection when the function is called. I don't have a strong preference for the site used (e.g. yahoo, msn, etc). I plan to call the function many times within the same spreadsheet for different symbols. The values (quotes) should be refreshed when the spreadsheet is recalculated. I will pay more for features such as a parameter for getting the bid, ask, volume, or time of last trade instead of the last price. I will be building spreadsheets based on the stock quotes. It is important that the function not affect any part of the spreadsheet except the cell from which it was called. The program needs to be documented in English particularly where parsing is done. If the source site changes its layout then we will have to know what code to modify. =StockQuote(symbol) or =StockQuote(symbol, type) where type is a parameter equal to last, bid, ask, volume, or time. Last is the default if the type is omitted.

## Deliverables

Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.


## Platform

Microsoft Excel 2002 for Windows.

Post a Project Like This

This project was awarded to

bijak

Michael completed the project on time. It was to spec, well within the allotted time, with documentation. It even went a bit beyond spec. I plan to use him again.
About the Freelancer
bijak Profile Picture

## BIO | **<font face="Verdana, Arial, Helvetica, sans-serif" size= "2">EDUCATION</font>** <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Lamar University Beaumont, TX</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Earned Bachelor of Science in Electrical Engineering and Computer Science</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">3.82 GPA</font> <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">**WORK EXPERIENCE**</font> July 2001 - November 2001 WorldCom Richardson, TX Electrical Engineer * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Participated in WorldCom's Engineering Develpment Program</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Tested, configured, and sovled problems with SONET network equipment from vendors such as Nortel and Fujitsu.</font> <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">January 1998 - July 2001 Compu – Tech, Inc. Nederland, TX Programmer</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Ported municipal court management system software from IBM AS/400 system to Microsoft Windows platform via Visual Basic</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Responsible for implementation, testing & debugging, delivery of final product, and customer support</font> <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">**PROFESSIONAL & HONOR SOCIETY MEMBERSHIPS**</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">I.E.E.E. member since Fall 1999 and former V.P. of Lamar U. student branch</font> * Tau Beta Pi engineering honor society member since Fall 1998 * Eta Kapp Nu Electrical Engineering honor society member since Spring 1999 * Phi Kappa Phi honor society member since Spring 2000 <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">**AWARDS AND HONORS RECEIVED**</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Charles & Susan Gordon Scholarship recipient in Fall 1996</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Dean's List Recognition from Spring 1997 to Fall 1999</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">President's List Recognition in Spring 1999</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Selected for All American Scholar recognition in Spring 2000</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Robert Harlow Electrical Engineering Scholarship recipient Fall 2000</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Budwine Charitable Foundation Scholarship recipient in Fall 2000</font> <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">**COMPUTER & HARDWARE SKILLS**</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Proficient with C, C++, Java, Visual Basic</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Experience using assembly language and C#</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Experience programming & debugging using Motorola HC12 microcontroller</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Experience with Unix, Linux, Windows NT/2000/9x</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Digital design experience using Xilinx FPGAs</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Experience testing and configuring SONET network equipment </font> |

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • bijak Profile Picture

    bijak

    United States

    ## BIO | **<font face="Verdana, Arial, Helvetica, sans-serif" size= "2">EDUCATION</font>** <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Lamar University Beaumont, TX</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Earned Bachelor of Science in Electrical Engineering and Computer Science</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">3.82 GPA</font> <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">**WORK EXPERIENCE**</font> July 2001 - November 2001 WorldCom Richardson, TX Electrical Engineer * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Participated in WorldCom's Engineering Develpment Program</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Tested, configured, and sovled problems with SONET network equipment from vendors such as Nortel and Fujitsu.</font> <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">January 1998 - July 2001 Compu – Tech, Inc. Nederland, TX Programmer</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Ported municipal court management system software from IBM AS/400 system to Microsoft Windows platform via Visual Basic</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Responsible for implementation, testing & debugging, delivery of final product, and customer support</font> <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">**PROFESSIONAL & HONOR SOCIETY MEMBERSHIPS**</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">I.E.E.E. member since Fall 1999 and former V.P. of Lamar U. student branch</font> * Tau Beta Pi engineering honor society member since Fall 1998 * Eta Kapp Nu Electrical Engineering honor society member since Spring 1999 * Phi Kappa Phi honor society member since Spring 2000 <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">**AWARDS AND HONORS RECEIVED**</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Charles & Susan Gordon Scholarship recipient in Fall 1996</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Dean's List Recognition from Spring 1997 to Fall 1999</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">President's List Recognition in Spring 1999</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Selected for All American Scholar recognition in Spring 2000</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Robert Harlow Electrical Engineering Scholarship recipient Fall 2000</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Budwine Charitable Foundation Scholarship recipient in Fall 2000</font> <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">**COMPUTER & HARDWARE SKILLS**</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Proficient with C, C++, Java, Visual Basic</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Experience using assembly language and C#</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Experience programming & debugging using Motorola HC12 microcontroller</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Experience with Unix, Linux, Windows NT/2000/9x</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Digital design experience using Xilinx FPGAs</font> * <font face="Verdana, Arial, Helvetica, sans-serif" size= "2">Experience testing and configuring SONET network equipment </font> |

    PHP, C Programming, Java, and Visual Basic

  • rkumarvw Profile Picture

    rkumarvw

    Panchkula,  India

    ## BIO More than 11 years of professional software development experience in the area of application software. This includes Network Administration, Analysis, Design, Development, Testing and Implementation of Commercial applications. **Strengths Include:** Analysis Design Development Network Administration **Platform :** Windows NT/98, Novell Netware,Linux **Languages :** Visual Basic 6.0, Visual Foxpro 6.0, Foxpro 2.x, C, VB Script/ASP, HTML/DHTML. **Database :** Oracle 8i, SQL Server 7.0, MS Access ,XBASE DBMSs. ## Area of Expertise I am proficient with PHP, WordPress, Joomla, Magento, Codeigniter, CakePHP, , HTML5, CSS3, Foundation ZURB, Bootstrap, JavaScript, jQuery, Responsive Design, Theme Customization, PayPal Integration, PayPal Gateway, Plug-in development API Integration,etc. Visual Basic 6.0,, ADO, ASP,, Visual Foxpro 6.0, Foxpro , Oracle,PL/SQL, Windows API,HTML,VBScript

    PHP, ASP, C Programming, and Visual Basic

  • jademtech Profile Picture

    jademtech

    Canada

    ## BIO **academics** I am a graduate in Computer Science, Human Biology, and Psychology from the University of Toronto. My specialization within the field of Computer Science is Human-Computer Interaction. ## Area of Expertise | Programming Languages | | * Java * Assembly (x86 through PMMX; DOS,Win32) * HTML,CSS, ASP, PHP, JavaScript * Python * SQL programming * C, C++, Objective-C | | Computer Graphics | | * CG modelling, texturing * CG animation * CG post production work * Vector and raster image packages * Image enchancement and restoration * 35mm photography * Photo/Digital imagery compositing |

    PHP, ASP, C Programming, and Java

  • jayjuch Profile Picture

    jayjuch

    United States

    ## BIO I've been professionally developing software since 1993. I hold a B.S. in Computer Science. Started out my career developing banking software in wall street and later moved into new media and internet related projects. Secure, robust, scalable and distributed systems development is also my speciality. My last project can be seen here: http://cable.webscrivener.com ## Area of Expertise I am a strong Windows C++ programmer. Current and solid work experience with the following technologies (in no particular order): COM/DCOM, ATL, MFC, browser programming, threading, DLL's, services, winsock, IOCP, CryptoAPI, SSL, ODBC, ADO. I also have strong skills in web technologies: ASP (VBScript), IIS, SQL Server, HTML, DHTML/Javascript, Java (applets and standalone), perl, PHP, MySQL, Apache, XML.

    PHP, Perl, ASP, and C Programming

  • customcodervw Profile Picture

    customcodervw

    Mount Pleasant,  United States

    ## BIO ![][1] Extensive working experience of MSSQL, MySQL, InterBase, Windows Programming, Database design & development. ![][1]Current Projects:   <img border="0" src="/RentACoder/images/bullet.gif" width= "12" height="12" /> Client/Server Web based application for a delivery service.   <img border="0" src="/RentACoder/images/bullet.gif" width= "12" height="12" /> Billing application for Water Supply Corp. (Completed App, just doing requested additions now)   <img border="0" src="/RentACoder/images/bullet.gif" width= "12" height="12" /> Monitoring application for Tube-Mill to do production on items when a particular item has been completed. ## Area of Expertise I have over 25 years of programming Experience.   I began programming on the TRS-80 Model I using Assembly Language.   Then BASIC and PASCAL (Turbo Pascal 3), then the Delphi series starting with 1.   I am now using Delphi 6. ![][1] SQL ![][1] ASP <img border="0" src= "https://www.rentacoder.com/RentACoder/images/bullet.gif" width= "12" height="12" /> PHP ![][1] ISAPI Objects ![][1] Project Management ![][1] Documentation ![][1] Web apps ![][1] Dealer Locators ![][1] feedback page

    PHP, Perl, ASP, and C Programming

  • jsmorgan24 Profile Picture

    jsmorgan24

    Saint Johns,  United States

    ASP, and Visual Basic

  • nettyvw Profile Picture
  • daidalos Profile Picture

    daidalos

    Cyprus

    ## BIO <p class="MsoBodyText2" style= "margin-top:12.0pt;margin-right:0in;margin-bottom: 0in;margin-left:130.3pt;margin-bottom:.0001pt;text-align:justify;text-indent: -112.3pt;tab-stops:.5in"> **Profile:**<span style= "mso-tab-count:1">                        </span> More than 10 years of experience with system development on different platforms, and in different programming languages. My specialities are Windows-programming in C and Visual Basic, 3-tier client-server system development, solutions integrating MS Office and Visual Basic for Applications, and Internet/Intranet solutions with Active Server Page and Javascript programming. In later years I have almost allways used objectoriented design and development in a COM/DCOM framework.</p> <span style= "mso-bidi-font-weight: normal; mso-bidi-font-size: 10.0pt; font-family: Times New Roman; mso-ansi-language: EN-US"> <b style= "mso-bidi-font-weight: normal; mso-bidi-font-size: 10.0pt; font-family: Times New Roman; mso-ansi-language: EN-US"> Among a lot of other projects, the following are of special interest: </b></span> <p class="MsoNormal" style= "margin-top:2.0pt;margin-right:0in;margin-bottom:2.0pt; margin-left:.25in;text-indent:-.25in;mso-list:l8 level1 lfo10;tab-stops:list .25in"> <span style= "font-family:Symbol;mso-ansi-language:EN-US">·<span style="font:7.0pt" times="" new= "">       </span></span> Design and programming of an application to simulate demographic development and the following need of day care capacity, programmed in VBA in Excel as a client of a DB2 database backend.</p> <p class="MsoNormal" style= "margin-top:2.0pt;margin-right:0in;margin-bottom:2.0pt; margin-left:.25in;text-indent:-.25in;mso-list:l8 level1 lfo10;tab-stops:list .25in"> <span style= "font-family:Symbol;mso-ansi-language:EN-US">·<span style="font:7.0pt" times="" new= "">       </span></span> Calculation components for an application, that dimensioned the sizes of different elements in turn key delivered cement factories for F.L. Schmidt, developed in the Access of Office 95.</p> <p class="MsoNormal" style= "margin-top:2.0pt;margin-right:0in;margin-bottom:2.0pt; margin-left:.25in;text-indent:-.25in;mso-list:l1 level1 lfo11;tab-stops:list .25in"> <span style= "font-family:Symbol;mso-ansi-language:EN-US">·<span style="font:7.0pt" times="" new= "">       </span></span> A statistic system for reporting statistics on the daily sales of shopping centers, based on dataimport from a Oracle database. Programmed in Visual Basic, Sheridan Data Widgets, Spy Works and DAO with the use of Excel and Access as components delivering report and Pivot statistics capabilities to the application.</p> <p class="MsoNormal" style= "margin-top:2.0pt;margin-right:0in;margin-bottom:2.0pt; margin-left:.25in;text-indent:-.25in;mso-list:l18 level1 lfo15;tab-stops:list .25in"> <span style= "font-family:Symbol;mso-ansi-language:EN-US">·<span style="font:7.0pt" times="" new= "">       </span></span> Developed print out and storage components for a real estate sales management program, developed with Visual Basic, COM, OLE , VBA in MS Word 97,  RDO, SQL Server 6.5 etc.</p> <p class="MsoNormal" style= "margin-top:2.0pt;margin-right:0in;margin-bottom:2.0pt; margin-left:.25in;text-indent:-.25in;mso-list:l22 level1 lfo17;tab-stops:list .25in"> <span style= "font-family:Symbol;mso-ansi-language:EN-US">·<span style="font:7.0pt" times="" new= "">       </span></span> Developed a new statistics system in ODBC, VBA og Excel 97 against an ORACLE database for Elkraft in Denmark.</p> <p class="MsoNormal" style= "margin-top:2.0pt;margin-right:0in;margin-bottom:2.0pt; margin-left:.25in;text-indent:-.25in;mso-list:l13 level1 lfo3;tab-stops:list .25in"> <span style= "font-family:Symbol;mso-ansi-language:EN-US">·<span style="font:7.0pt" times="" new= "">       </span></span> Made add-ins og COM addins in Excel 2000 and VBA and VB for danish auditors.</p> <p class="MsoNormal" style= "margin-top:2.0pt;margin-right:0in;margin-bottom:2.0pt; margin-left:.25in;text-indent:-.25in;mso-list:l13 level1 lfo3;tab-stops:list .25in"> <span style= "font-family:Symbol;mso-ansi-language:EN-US">·<span style="font:7.0pt" times="" new= "">     </span></span> Developed an electronic auction  system for the government of the Netherlands. The applications was developed as DCOM distributed components on a NT 4.0 LAN by using Visual Basic 6.0, SQL Server 7.0, Desaware Spyworks and Videosofts Flexgrid etc. I have also programmed a server side security check component in Visual C++ and Microsoft Crypto API.</p> <p class="MsoNormal" style= "margin-top:2.0pt;margin-right:0in;margin-bottom:2.0pt; margin-left:21.0pt;text-indent:-.25in;mso-list:l6 level1 lfo2;tab-stops:list .25in"> <span style= "font-family:Symbol;mso-ansi-language:EN-US">·<span style="font:7.0pt" times="" new= "">     </span></span> Just finished a workflow application for Post Danmark, the Danish mail delivery organization. It has managed the transformation of 12.000 civil servants to employees on agreement terms, and involved payment reporting to the larger payment data system as well as statistical functions and mail merge functions for all the paperworks in the matter. It was developed in Access with the use of Excels pivot tables etc. and enhanced Word mail merge functions.</p> ## Area of Expertise Microsoft C Windows programming Visual Basic Visual Basic for Applications SQL ASP VBScript JavaScript HTML COM DCOM ADO ODBC SQL Server Oracle Access programming All Windows operating systems Excel programming Word programming OLE automation Active X

    PHP, Perl, C Programming, and Java

  • psergei Profile Picture

    psergei

    Kharkov,  Ukraine

    **Professional Employment** since 1997 Project management, system analyst, presentation, database and business logic programming. **Education** Kharkov National University, Faculty of Mechanics and Mathematics. Applied Math Masters degree. **Foreign Languages** Native language is Russian. Fluent skills in spoken English. Fluent in written English. **Communication: ** I'm available on mail, Skype, Google

    Javascript, iPhone, Testing / QA, and SQL

  • tzachh Profile Picture

    tzachh

    Israel

    ## BIO 17 years of experience in programming, Design and Software Project management. I've worked or performed consulting for IBM, Veritas Software, Digital, several Hi Tech and Startup companies. ## Area of Expertise Operating Systems: Windows, Linux, Unix. Langs: C#, C++, Java, C, VB.Net, VB, ADA, Fortran. DBs: Oracle, Sql Server, MySql, Access, Sybase. Methodologies and APIs: J2EE, JNI, J2EE CA, JNDI, .NET, COM+, MSMQ, MTS, MFC. Servers: Apache, Tomcat, IIS, Squid, WebSphere, Weblogic, Biztalk

    PHP, ASP, C Programming, and Java