
Pulling figures from the website and updating google spreadsheet
- or -
Post a project like this3089
€50(approx. $60)
- Posted:
- Proposals: 4
- Remote
- #1643264
- Completed
Description
Experience Level: Intermediate
I have a google file https://docs.google.com/spreadsheets/d/1Jxc667AyeIq7aXXBIlbvAaXR3jFnYldEtZfeRgCaXoc/edit#gid=84669383
There are few tabs EURUSD, GBPUSD, USDJPY, AUDUSD, USDCAD
I update columns A,B,C,D,F for each tab.
The data comes from here http://www.cftc.gov/dea/futures/deacmesf.htm
For example
In the first tab EURUSD there are few columns:
Date, longs, shorts, open interest
The figures come from here the above link as per attached screenshot
CFTC also keeps these figures in the excel format here http://www.cftc.gov/files/dea/history/dea_fut_xls_2017.zip
The data is updated every Friday in the same location
Requirement:
I need to be able easily update my google sheet with:
Date, longs, shorts, open interest and populate the rest of columns in each tab.
At the moment, I update the file by coping and pasting but I need an automated way to pull the figures from the cftc website and update my google sheet.
There are few tabs EURUSD, GBPUSD, USDJPY, AUDUSD, USDCAD
I update columns A,B,C,D,F for each tab.
The data comes from here http://www.cftc.gov/dea/futures/deacmesf.htm
For example
In the first tab EURUSD there are few columns:
Date, longs, shorts, open interest
The figures come from here the above link as per attached screenshot
CFTC also keeps these figures in the excel format here http://www.cftc.gov/files/dea/history/dea_fut_xls_2017.zip
The data is updated every Friday in the same location
Requirement:
I need to be able easily update my google sheet with:
Date, longs, shorts, open interest and populate the rest of columns in each tab.
At the moment, I update the file by coping and pasting but I need an automated way to pull the figures from the cftc website and update my google sheet.
Roman S.
100% (1)Projects Completed
4
Freelancers worked with
4
Projects awarded
50%
Last project
24 Jul 2017
Ireland
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-

Do you need this to be done for Google spreadsheet ?
What if I save 4 different CSV files.
Thanks
Sumit
SaS TechnologiesRoman S.16 Jul 2017google sheet pls
-

Hey there.
Could you also show what values (cells) from the .zip excel file are used? It's quite big.Roman S.16 Jul 2017http://www.cftc.gov/files/dea/history/dea_fut_xls_2017.zip
consist anothe excel file "annual"
columns used as below
currency = Market_and_Exchange_Names ( search for euro,Canadian dollar etc)
date = Report_Date_as_MM_DD_YYYY
Open Interest = Open_Interest_All
Longs = NonComm_Positions_Long_All
Shorts = NonComm_Positions_Short_All
461726461683
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies