Forum Discussion

deniztopcu's avatar
deniztopcu
Frequent Visitor
4 years ago
Solved

download in one query

Hi everyone,

 

I have a query that downloads data for each symbol for a period.

---------------------------------------------------------------------------------------------------------

I want a query where I can download multiple periods (ex. 2022-2018) in the same query. 

-------------------------------------------------------------------------------------------------------

 

 

 

 

 

 

Need Help
  • KT_Bsmart2gethe's avatar
    KT_Bsmart2gethe
    4 years ago

    Hi deniztopcu ,

     

    I have simplified the queries. see the attached solution.

    New Solution 

    The challenge was the layout to get the rename part to work dynamically.

    I create an input table and turn the transformation query to fx.

     

    I hope it helps you and put you in the position for your priority matrix.

     

    Regards

    KT

7 Replies

  • KT_Bsmart2gethe's avatar
    KT_Bsmart2gethe
    Impactful Individual
    4 years ago

    Hi deniztopcu ,

     

    Please see the below link for the solutions.

    Solution 

    I modified your existing query by recycling your Financial URL and the SYMBOL table.

    Each step should be dynamic and not required to rename.

     

    Let me know if that is what you're looking for.

     

    Regards

    KT

     

    • deniztopcu's avatar
      deniztopcu
      Frequent Visitor
      4 years ago

      Hi KT_Bsmart2gethe,

      Thank you. It's a solution but that's not what I wanted.
      The result part is quite complex and I think the manual query I have is easier.

      I want to use the template I have and even convert my Template to matrix.

      • KT_Bsmart2gethe's avatar
        KT_Bsmart2gethe
        Impactful Individual
        4 years ago

        Hi deniztopcu ,

         

        Would you mind explaining a bit more about your desired outcome? (i.e. your end goal)

         

        My understanding is:

        1. You have a SYMBOL and URL list,

        2. You scrubbing off the Balance Sheet from the web,

        3. Up to the current step, we have the Balance Sheet. Are you saying that you want to use the template "Bos Bilanco" and turn it into a financial matrix (i.e. the working capital, liquidation ratio and such?)

         

        Regards

        KT

  • deniztopcu's avatar
    deniztopcu
    Frequent Visitor
    4 years ago

    Hi KT_Bsmart2gethe 

    Thank you so much. You worked hard for this. I'm marking the thread as solved and will try to digest what you wrote.

    best regards