Financial Metrics Template - Capital IQ

[Anonymous]

Has anyone ever created a template with financial information from Capital IQ?

Any tips as to how best to display ratios, balance sheet etc?

[v-piga-msft]

Hi @Anonymous ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best Regards,

Cherry

[Anonymous]

Hi, thaknks for the response. 

CapIQ is a database with financial infomation. I'm wondering if you can get a feed straight from the database into Power BI or at least into excel. 

[Anonymous]

Hi there, 

Have you resolved the issue? I also need to retrieve data from Capital IQ's database but couldn't figured out a way.

When I try to import the data from the website, I encounter with the initial web page where the log in information is required. Thereby, the URL that I enter to "From WEB" section of "Get Data" just does not work. When I view the results, log-in platform appears in the "Web View" tab and I cannot go further to the source that I need to connect to Power BI. 

Is there anything I can do?

Thanks in advance

[v-piga-msft]

Hi @Anonymous ,

I have a little confused about Capital IQ.

You may have a reference of this blog which may help you.

If you still need help, please share your desired output so that we could help further on it.

Best  Regards,

Cherry