Closed Thread
Results 1 to 2 of 2

Programmer wanted for integrated Excel / Access project

  1. #1
    Registered User
    Join Date
    03-27-2019
    Location
    Vancouver, WA. USA
    MS-Off Ver
    2010
    Posts
    2

    Programmer wanted for integrated Excel / Access project

    I have an Excel workbook that I use for collecting and analyzing Real Time Data from my broker. I track and calculate the supply & demand on 28 currency pairs across 9 different time frames. This is done on a minute-by-minute basis for 12 periods. The longest time period is 12 months, which requires 380,160 quotes for each currency pair. The exact process is proprietary, but the data load for all currency pairs amounts to over 9.7 million quotes. This is too much for Excel to deal with while simultaneously doing the calculations and graphing. My thoughts are to use an Access database to gather and store the data and link my Excel workbook to it so it can do the calculations, spit out the reports and paint the graphs I want to see. My problem is that I know nothing about Access, nor am I that proficient with VBA.

    This project would involve creating the database to my specifications and integrating the workbook. This could be done on a single dedicated computer which would run the database and the workbook, or as a database server in which a remote computer could access the database with a local copy of the workbook. My objective is speed and accuracy, so the setup which meets my objective best would be the one I would want.

    The freelancer I'm looking for would know both Access and Excel (and how they can work together) and (hopefully, but not essential) be in the Portland, OR area.

    The bare bones of the workbook is already done, I just need someone to create the Access database with the routine to collect the RTD data (either directly to Access from my broker or from an Excel workbook that collects the data) and create the link to my current analysis workbook.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    24,763

    Re: Programmer wanted for integrated Excel / Access project

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here. I am, therefore, closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-pro...ing-model.html

    If you wish to change the title of the original thread, where you have already had a response, then you can of course do so.

    If you are looking for someone to take on the entire project for payment, you should be posting in the Commercial Services section.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    Are you new to Power Query and don't know what to do with the code you've been given? Have a look here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1