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
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    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!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Programmer Rate (hourly/ daily/ per project)
    By abousetta in forum The Water Cooler
    Replies: 4
    Last Post: 08-01-2013, 08:47 AM
  2. Looking to Hire a Programmer for a Small Project
    By stusic in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-18-2013, 04:13 PM
  3. Hello. I'm new to this forum. I'm an Access/Excel VBA Database Programmer
    By Cheryl Zahn in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-20-2012, 01:14 PM
  4. Pay for a Access Programmer
    By jesika in forum Access Programming / VBA / Macros
    Replies: 4
    Last Post: 03-27-2009, 09:58 AM
  5. [SOLVED] ot - Wanted: Excel Programmer Writers in RedmondWanted: Excel Programmer Writers in Redmond
    By Gary Keramidas in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-08-2006, 08:55 AM
  6. [SOLVED] Import Access data into Excel - Looking for programmer
    By Harry in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-13-2005, 02:06 PM

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