Quantopian's community platform is shutting down. Please read this post for more information and download your code.
Back to Community
Unsupported operand type(s)
Sjors Wesselingh
posted Oct 30, 2019

Dear Quantopians,

Im new to Quantopian and im quite unexperienced in Python as wel. I did a course Python for finance Investment fundamentals/data analytics. Then i discoverd Quantopian and my mind was blown about the possibilities here.
Now i'm facing a problem in my notebook its about a unsupporterd operand type (*) for Boundcolumns in a Moringstar fundamental dataset. Probabely its a really basic/silly mistake i'm making, i did some rescearch but the answers on simular posts/problems i didn't fully understand. Can someone please explain what i'm doing wrong? Its propbaly in the data form of the dataset since i tried the notebook on the factset fundamentals dataset and my notbook worked fine.

This brings me to my second question: can someone help me out with a real-time (fundamental)dataset of European stocks, I can only find those data sets for US stocks.

Thanks in advance,

Sjors

2 responses
Jamie McCorriston
Oct 30, 2019

Hi Sjors - welcome!

I think all you are missing is a .latest at the end of each of the lines where you are defining your fundamentals terms. One important distinction to make in pipeline is the difference between a BoundColumn and a Factor. A BoundColumn (which is what you get when you type Fundamentals.<field>) informs pipeline about where to get the relevant column of data for each date in the simulation. However, you need to reduce this column to a single value per asset per day in order to include it in expressions with operators like <, &, *, +, etc.

If you instead write Fundamentals.<field>.latest, you will get back a pipeline Factor which you can then include in the output of your pipeline or in expressions with the operations listed above.

To learn more about pipeline, I'd highly recommend reading the pipeline user guide page in the documentation, as well as the pipeline tutorial. Specifically, lesson 3 of the tutorial talks about .latest.

Let me know if this helps.

Disclaimer

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 Quantopian. In addition, the material offers no opinion with respect to the suitability of any security or specific investment. No information contained herein should be regarded as a suggestion to engage in or refrain from any investment-related course of action as none of Quantopian nor any of its affiliates is undertaking to provide investment advice, act as an adviser to any plan or entity subject to the Employee Retirement Income Security Act of 1974, as amended, individual retirement account or individual retirement annuity, or give advice in a fiduciary capacity with respect to the materials presented herein. If you are an individual retirement or other investor, contact your financial advisor or other fiduciary unrelated to Quantopian about whether any given investment idea, strategy, product or service described herein may be appropriate for your circumstances. All investments involve risk, including loss of principal. Quantopian 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.

Sjors Wesselingh
Nov 3, 2019

Thanks for your quick response, i'm going to adjust my notebook :)

About Quantopian
Careers
Community
Events
Documentation
Academia
Lectures
Status
Facebook
Twitter
LinkedIn
YouTube
Terms of Use
Privacy Policy

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 Quantopian.

In addition, the material offers no opinion with respect to the suitability of any security or specific investment. No information contained herein should be regarded as a suggestion to engage in or refrain from any investment-related course of action as none of Quantopian nor any of its affiliates is undertaking to provide investment advice, act as an adviser to any plan or entity subject to the Employee Retirement Income Security Act of 1974, as amended, individual retirement account or individual retirement annuity, or give advice in a fiduciary capacity with respect to the materials presented herein. If you are an individual retirement or other investor, contact your financial advisor or other fiduciary unrelated to Quantopian about whether any given investment idea, strategy, product or service described herein may be appropriate for your circumstances. All investments involve risk, including loss of principal. Quantopian 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.