Forum Discussion

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

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)

multiple_Stock.xlsx33 KB

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)

multiple_Stock.xlsx33 KB