Five Minute Dynamic Data

$10-30 USD

Completed

Posted

over 5 years ago

$10-30 USD

Paid on delivery

I am a trader and I'm looking for a dynamic spreadsheet that updates data every five minutes from another spreadsheet. My source and spreadsheet data is from "Master Import" which is connected to a website and refresh the connection every five minutes from Sheet2 to Sheet9, and placing the numbers I want in Sheet1. I would like to have another spreadsheet saving the results every five minutes automatically see sample "FiveMin5D28pairsData" that have 1,740 rows of five minutes data from 28 currency pairs plus 1 row for the columns name (total of 1,741 rows). It has to be sorted from oldest on top to the newest on the bottom and every time a new five minutes refresh delete the old one (first row data) and insert the new one to the bottom keeping the same amount of rows at all time.

Project ID: 18359692

About the project

7 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

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

Awarded to:

@JadavSaikrishna

Hi Friend, I understood your requirement. I can do this project easily because I have been developing and making the changes in Excel applications using VBA and SQL from last 6 years. Also, I have 4 years’ experience in support project in which I had to work for clients from USA, UK, and Singapore. I got appreciations from clients like British Petroleum and Wipro Technologies for making user-friendly applications for their requirements i.e. 1) Extraction of data from Database and website for presentation. 2) Automated Email notifications with calculations. 3) Adding buttons for a specific function/requirement. 4) Comparing the cells with their data. 5) Formatting the spreadsheet and sending automated emails. 6) Searching, sorting, copy and pasting the data appropriately. 7) Changes to the old macros by standardizing the code. 8) Adding Add-Ins. 9) SQL procedures for automated functions and more... I can write VBA code for your requirement. Please let me know if more information is required from my side. Thank you.

$25 USD in 3 days

4.7

(3 reviews)

1.3

7 freelancers are bidding on average $26 USD for this job

@roshanasim

I have worked on Web Data Mining- Web Harvesting- Email address and contact detail extraction from web- Web data collection- Plain data entry- JPG/PDF to DOC file- Entry in Excel/ACT- Link Exchange on the web. Data Transcription- Conversion – Processing – Typing – File Conversion. I can help you on your any data entry task. Simple to expert I shall be always available and can work overtime if necessary. Thank You sir i did projects like this kindly reply i want to discuss it with you

$28 USD in 1 day