Share New Research 
I want to include a list of symobls from a file in my Universe Selection. There is an example in the Docs of using Dropbox. Has anyone tried this approach using Google Docs ? I'd appreciate any example code.
QUANTCONNECT COMMUNITY
The material on this website is provided for informational purposes only and does not constitute an offer to sell, a solicitation to buy, or a recommendation or endorsement for any security or strategy, nor does it constitute an offer to provide investment advisory services by QuantConnect. In addition, the material offers no opinion with respect to the suitability of any security or specific investment. QuantConnect makes no guarantees as to the accuracy or completeness of the views expressed in the website. The views are subject to change, and may have become unreliable for various reasons, including changes in market conditions or economic circumstances. All investments involve risk, including loss of principal. You should consult with an investment professional before making any investment decisions.
QuantConnect™ 2024. All Rights Reserved
Derek Melchin
Hi Angus,
The attached notebook demonstrates how to download from a Google Docs spreadsheet.
Best,
Derek Melchin
The material on this website is provided for informational purposes only and does not constitute an offer to sell, a solicitation to buy, or a recommendation or endorsement for any security or strategy, nor does it constitute an offer to provide investment advisory services by QuantConnect. In addition, the material offers no opinion with respect to the suitability of any security or specific investment. QuantConnect makes no guarantees as to the accuracy or completeness of the views expressed in the website. The views are subject to change, and may have become unreliable for various reasons, including changes in market conditions or economic circumstances. All investments involve risk, including loss of principal. You should consult with an investment professional before making any investment decisions.
Robot 001
Do you have an updated on how to pull data from Google Docs Spreadsheet? I tried using the example in the notebook, but it return a bunch of HTML codes….
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta content="width=300, initial-scale=1" name="viewport">
<meta name="description" content="Create a new spreadsheet and edit with others at the same time – from your
computer, phone or tablet. Get stuff done with or without an internet connection. Use Sheets to edit Excel files. Free
from Google.">
Fred Painchaud
Hi Robot,
It looks like the Google website is returning you a webpage to create a new spreadsheet instead of the spreadsheet you are looking for. You most probably need to change the URL a bit so it returns the spreadsheet itself but I am not sure that Google Docs can return a plain CSV file (I am guessing that your spreadsheet is really a CSV file, not an Excel file) without any HTML wrap around it. If you can share your URL to your spreadsheet, I can certainly look into it or you can Google around to see how Google Docs can return the documents themselves and not webpages of the documents.
But I believe you have more chances of success with Google Drive instead of Google Docs. It's not impossible I guess with Google Docs but Google Docs is more like a web version of Office (ish) for collaboration.
Fred
Robot 001
Hi Fred,
Thanks for reaching out. I manage to get it to work in the end (both Google Docs & Google Drive).
For Google Drive, you use share > copy link (remember to change setting to: "Anyone on the internet with this link can view") . You will get something like below:
https://drive.google.com/file/d/<FILE_ID>/view?usp=sharing
Change to:
https://drive.google.com/uc?export=download&id=<FILE_ID>
While for Google Docs (CSV), do the same thing as above to get the link, and you should get something like:
https://docs.google.com/spreadsheets/d/<FILE_ID>/edit?usp=sharing
Change to:
https://docs.google.com/spreadsheets/d/<FILE_ID>/export?format=csv
cheers
Angus MacDonald
The material on this website is provided for informational purposes only and does not constitute an offer to sell, a solicitation to buy, or a recommendation or endorsement for any security or strategy, nor does it constitute an offer to provide investment advisory services by QuantConnect. In addition, the material offers no opinion with respect to the suitability of any security or specific investment. QuantConnect makes no guarantees as to the accuracy or completeness of the views expressed in the website. The views are subject to change, and may have become unreliable for various reasons, including changes in market conditions or economic circumstances. All investments involve risk, including loss of principal. You should consult with an investment professional before making any investment decisions.
To unlock posting to the community forums please complete at least 30% of Boot Camp.
You can continue your Boot Camp training progress from the terminal. We hope to see you in the community soon!