Five Minute Dynamic Data

$10-30 USD

Teljesítve

Kiadva ekkor:

több mint 5 évvel ezelőtt

$10-30 USD

Teljesítéskor fizetve

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.

Projektazonosító: 18359692

A projektről

7 ajánlat

Távolról teljesíthető projekt

Aktiválva: 5 évvel ezelőtt

Szeretne pénzt keresni?

E-mail cím

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet

Kapja meg fizetését a munkáért

Vázolja ajánlatát

Ingyen regisztrálhat és adhat árajánlatot munkákra

Neki odaítélve:

@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 3 napon belül

4,7

(3 értékelés)

1,3

7 szabadúszó adott átlagosan $26 USD összegű árajánlatot erre a munkára

@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 1 napon belül