Forum Discussion

deniztopcu's avatar
deniztopcu
Frequent Visitor
4 years ago
Solved

Download Multiple stock Price

Hello, This is in need of help. I am not proficient in M ​​language. I am trying.  I think there is a problem in this part. ----------------------------------------------------------------...
Need Help
  • ImkeF's avatar
    ImkeF
    4 years ago

    Hi deniztopcu ,
    looks like changing your query to:

     

     

    (Symbol as text) =>
let
  //Symbol = "FENER",
    BaseURL = Excel.CurrentWorkbook(){[Name="Çeyrek_URL"]}[Content],
    #"Added Custom" = Table.AddColumn(BaseURL, "ModifiedURL", each Text.Replace([URL],"SYMBOL",Symbol)),
    ///????

    #"Değiştirilen Tür" = Table.TransformColumnTypes(#"Added Custom",{{"Ceyrek", type date}, {"URL", type text}}),
    
    #"Özel Eklendi" = Table.AddColumn(#"Değiştirilen Tür", "Özel", each fnQuarterPrice([ModifiedURL])),
    #"Removed Errors" = Table.RemoveRowsWithErrors(#"Özel Eklendi", {"Özel"}),
    #"Kaldırılan Hatalar" = Table.RemoveRowsWithErrors(#"Removed Errors", {"Özel"}),
    #"Genişletilen Özel" = Table.ExpandTableColumn(#"Kaldırılan Hatalar", "Özel", {"Column1.HGDG_KAPANIS"}, {"Özel.Column1.HGDG_KAPANIS"}),
    #"Kaldırılan Yinelenenler" = Table.Distinct(#"Genişletilen Özel")
in
    #"Kaldırılan Yinelenenler"

     

     

    does the job.
    (Attached file as well)

ImkeF's avatar
ImkeF
Community Champion
4 years ago

Hi deniztopcu ,
looks like changing your query to:

 

 

(Symbol as text) =>
let
  //Symbol = "FENER",
    BaseURL = Excel.CurrentWorkbook(){[Name="Çeyrek_URL"]}[Content],
    #"Added Custom" = Table.AddColumn(BaseURL, "ModifiedURL", each Text.Replace([URL],"SYMBOL",Symbol)),
    ///????

    #"Değiştirilen Tür" = Table.TransformColumnTypes(#"Added Custom",{{"Ceyrek", type date}, {"URL", type text}}),
    
    #"Özel Eklendi" = Table.AddColumn(#"Değiştirilen Tür", "Özel", each fnQuarterPrice([ModifiedURL])),
    #"Removed Errors" = Table.RemoveRowsWithErrors(#"Özel Eklendi", {"Özel"}),
    #"Kaldırılan Hatalar" = Table.RemoveRowsWithErrors(#"Removed Errors", {"Özel"}),
    #"Genişletilen Özel" = Table.ExpandTableColumn(#"Kaldırılan Hatalar", "Özel", {"Column1.HGDG_KAPANIS"}, {"Özel.Column1.HGDG_KAPANIS"}),
    #"Kaldırılan Yinelenenler" = Table.Distinct(#"Genişletilen Özel")
in
    #"Kaldırılan Yinelenenler"

 

 

does the job.
(Attached file as well)

  • deniztopcu's avatar
    deniztopcu
    Frequent Visitor
    4 years ago

    Thank you so much. For your efforts in this thread. A very positive result for me.🌻🌻🌻