How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask ATLPROG Your Own Question

ATLPROG
ATLPROG, Computer Software Engineer
Category: Programming
Satisfied Customers: 7677
Experience:  MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
44910485
Type Your Programming Question Here...
ATLPROG is online now
A new question is answered every 9 seconds

I need help with a current VBA file i have created to

Customer Question

I need help with a current VBA file i have created to calculate comparison rates that lenders in Australia display on their websites. I need to get the output to be within one hundredth of a percent however, something needs tweaking and i need some help with it.
Submitted: 4 months ago.
Category: Programming
Expert:  Bhavik Joshi replied 4 months ago.

Hi Ross, Welcome to JustAnswer.

I would like to give it a try, Could you please share your excel file with me?

Customer: replied 4 months ago.
Please see attached the outputes from API for the data to be entered into the VBA file"success": true,
"list": [{
"uniqueId": "CMEL010910:78739d7d-d2b2-4c66-89b2-e14c31b47641",
"company": null,
"isDeleted": null,
"deletedBy": null,
"deletedOn": null,
"createdOn": null,
"createdBy": null,
"isNew": null,
"lenderId": "ADE",
"lenderName": null,
"lenderNameShort": "ADE",
"productType": "Fixed Full Doc",
"ufcRate": 0.0,
"tcRate": 0.0,
"active": true,
"maxTerm": 30,
"assessmentTerm": 30,
"maxLoanSize":(###) ###-####0,
"minLoanSize": 10000.0,
"shortName": "SmartFix (Fixed)",
"productName": "SmartFix Fixed - Owner Occupied",
"assessmentRate": 7.75,
"baseRate": 4.26,
"discountRate": null,
"comments": "This is a fully featured Fixed home loan with all the benefits of a transactional 100% offset account that lets you see at a glance what you owe and what you own because the offset balance is shown separately.",
"states": "All",
"initialRate": 4.19,
"fixedYears": 2,
"totalInterest": null,
"totalFees": null,
"totalCost": null,
"endBalance": 0.0,
"totalMonthlyFees": null,
"totalAnnualFees": null,
"totalSetupFees": null,
"numberOfRequestedFeatures": "1 of 0",
"rateChangeDate": "2015-11-20",
"previousRate": 4.64,
"timeToPay": null,
"defaultTotalCost": null,
"baseRepayment": null,
"isOnSpecial": false,
"specialDetails": null,
"lvr": 95.0,
"maxLvrInvestment": 0.0,
"maxLvr": 0.0,
"setUpFee": 495.0,
"monthlyFee": 15.0,
"annualFee": 0.0,
"discountApplied": 0.4,
"rates": [{
"uniqueId": "3F7712F2-1F00-95FF-5316-CE856D836626",
"company": null,
"isDeleted": null,
"deletedBy": null,
"deletedOn": null,
"createdOn": null,
"createdBy": null,
"isNew": null,
"productId": "CMEL010910",
"rateNumber": 2,
"rate": 4.19,
"duration": 2.0,
"type": "Fixed",
"noDiscount": false,
"rateChangeDate": "2016-02-11",
"previousRate": 4.49,
"repayment": null,
"discountOverride": 0.0,
"hasOverriddenDiscount": false,
"discountApplied": 0.0Also the VBA file cant be attached over this medium. Do you have an email i can send it to you ?
Customer: replied 4 months ago.
Please view File here https://www.dropbox.com/s/c1bskmkaptgx0fm/Comparison%20rate%20formula.xlsm?dl=0
Customer: replied 4 months ago.
I need to calculate the variables to create the correct comparison rate if you have any questions please ask as it is a complex problem
Customer: replied 4 months ago.
Expert:  Bhavik Joshi replied 4 months ago.

I have downloaded it. Give me a moment. I will go through your sheet

Expert:  Bhavik Joshi replied 4 months ago.

Is this data is coming from chrome extension camelcamel ?

Expert:  Bhavik Joshi replied 4 months ago.

It would be great if you could give me an example like currently what you are getting at which column and what value it should display.Also let me know the logic/mathematical calculation which needs to be applied to get correct results.

Customer: replied 4 months ago.
Based on the information in the API output it needs to be entered into the VBA file columns. It would be a whole lot easier to explain via phone or skype/screenshare
Customer: replied 4 months ago.
No data is coming from a third party API that i have access to. The bot***** *****ne is I need to find out how to calculate comparison rates can you help me do that ? A comparison rate is the initial home loan rate plus any fees and charges over life of the loan added in and converted to a % All lenders must display these E.G www.westpac.com/homeloanratesAlso see attached formula which you could make your own from start based on it.
Customer: replied 4 months ago.
There are 2 types of rates variable with only one time period and initial rate and then fixed with an initial time at initial rate then remaining period with revert rate and the calculation must do both.
Customer: replied 4 months ago.
I really need a solution and will go elsewhere if this is something that you are not able to help with ?