Find Jobs
Hire Freelancers

create a macro that grabs data from a .js table on a webpage and enter it into a customised spread sheet.

$30-250 AUD

Closed
Posted over 8 years ago

$30-250 AUD

Paid on delivery
I am a currency trader and i compare correlation between different currency pairs as an added measure to detect shifts in the market. The online data source i need to get the correlation data from is in a .js database. see the following link... please ensure the "table" option is selected. [login to view URL] Features of the excel sheet I need created.... > Must create a new spreadsheet each week. > The time field should also have the date so it reads like this "08/12/2015 - 01:00" > Time needs to be in 24hr time > If the signal shows "Possible Turn" it should Fill red and if possible blink. > Instead of FALSE the box should show nothing if the data is yet to be grabbed and if it doesn't meet the condition it should show "Maintain" >Data needs to be grabbed every 30 minutes >Needs to run from 6am Monday morning to 7am Saturday Morning (if automatic timing cant be done a simple button on the sheet activating the macro will suffice) > Needs to grab data from the table from 20 different currency pairs in the table each time. > The field EUR/USD needs to be selected each time to ensure it correlates correctly. EUR/USD is the default when you go to the site so this shouldn't be an issue but just thought I would mention it. > A sound file will be provided that needs to play every time a "Possible Turn" condition is reached. Just needs to play once. > The spreadsheet needs to save every 1hr to avoid lost data. All the above is mentioned on the attached file also.
Project ID: 9078990

About the project

6 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
6 freelancers are bidding on average $200 AUD for this job
User Avatar
Hello! I work with Excel and VBA for last 5 years and have created hundreds of different scripts, including different web scrapers, including RacingPost, betfair, OddsPortal and a lot of others. Also I have degree at math, and experience at international bank as corporate risk officer ( 4 years), have a lot experience with data managing I will create script, that will be able to connect Your server using ODBC, then filter results for different currency pairs. When You will press "Update" button, my prog will connect to server and update data/charts/queries/povots. I will create summary on the top of the page. If You need somebody who can manage really difficult thing, I am right person, I am not guy who use recorded or stolen scripts, i have good background in VBA, and all my scripts work with 100% accuracy and performance. Hope for Your respond, Regards, Vlad.
$249 AUD in 5 days
4.9 (47 reviews)
6.8
6.8
User Avatar
Hi, I have more than 14 years of Data scarping and VBA/Excel exp and I am expert in this kind of work. I have completed more than 260 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$200 AUD in 5 days
4.9 (121 reviews)
6.3
6.3
User Avatar
The excel sheet can use vba to open internet explorer and grab all the required information and store it in excel. Time function can be used only if excel is always kept open and system is running. Although we can hide excel to background.
$200 AUD in 7 days
5.0 (14 reviews)
3.8
3.8
User Avatar
Expert in advance excel functions including creating Macro's. Looking forward to hearing from you to discuss this further. Regards.
$150 AUD in 2 days
5.0 (1 review)
1.0
1.0
User Avatar
A proposal has not yet been provided
$200 AUD in 5 days
0.0 (0 reviews)
2.3
2.3

About the client

Flag of SWITZERLAND
Switzerland
0.0
0
Member since Dec 8, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.