VBA help

  • [xpost][/xpost]

    Each day, an input file 'DB_PX_LAST' will be received, which contains a snapshot of historical prices provided by the data vendor.

    Build a macro that picks data from these input files, and populates the prices from 10th to 15th Nov into their respective cells, in the 'Prices Database' workbook.

    US0003M and SOFRRATE are Rates being available on T-1 basis.

    For example on 10th Nov, Rates as of 9th Nov will be populated into the 'Prices Database' workbook.

    Based on the information available, please make the necessary assumptions for holiday handling.

    Elaborate clearly the assumptions made, and your thought process behind.

    Whenever possible, incorporate sanity checks and controls to the macro, helping users to detect potential issues or errors for this process.

  • Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the URL from the address bar in your browser) to the cross-post. We are here to help so help us help you!

    Read this to understand why we ask you to do this


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!