Exchange Rates of Georgia Bank

Hello, I want to take exchange rates of Georgia Bank.But I didn't find URL.What is the XML Url of Georgia Bank?

Hello Mesut,

can you give a link to the website of the bank with which you want to make an exchange?

Hello.
Here's the link. Go to this link and you will find all the rates from National Bank of Georgia.

https://www.nbg.gov.ge/rss.php

There is a function for Turkey Bank.I have changed Url with Georgia Bank.How can I set date part in the URL.

Function GetValidResult(Val CurrDate)

//   "https://www.tcmb.gov.tr/kurlar/" + str1 + "/" + str2 + ".xml"

While True Do
str1 =  Format(CurrDate ,"DF=yyyyMM");
str2 =  Format(CurrDate ,"DF=ddMMyyyy");

StrFullAddres = "https://www.nbg.gov.ge/rss.php";
XMLFile = GetFilesFromInternet.DownloadFileToTempStorage(StrFullAddres);

If XMLFile.Status Then
BinaryData = GetFromTempStorage(XMLFile.Path);
XML = GetStringFromBinaryData(BinaryData);

mXml = New XMLReader;
mXml.SetString(XML);
Result = XDTOFactory.ReadXML(mXml);
mXml.Close();
DeleteFromTempStorage(XMLFile.Path);
Return Result;
EndIf;

CurrDate = AddDay(CurrDate, -1);
EndDo;
EndFunction

You can set date as a parameter:

https://www.nbg.gov.ge/rss.php?date=2020-10-30

For more info you can contact their tech support. I guess they'll help you.

Okey thank you very much!

You said a link about exchanges rate of Georgia Bank.But it is not What I want.I need an address that I can send date parameters and I can take data in order to dates.

I have searched it and also send a email to Georgia Bank but, Both I didn't find it and Georgia Bank has not reply the email.Can you help me please?

Hello,

I want to take exchange rate from Georgia Bank using this XML(https://www.nbg.gov.ge/rss.php).And then I want to save its date and rates in an information register.How can I write this code?

Hi Mesut,

you need to parse this XML file - the structure of this file is very simple (please see screenshot 1).

After that you can find the currency you are interested in, for example, the Turkish lira and its rate in relation to the Georgian currency (screen 2).

Aleksandr

Attached Files

Download 1.png (261.08 KB)

Download 2.png (271.14 KB)

I dont know how to take rates from XML or parsing.Have you any examples or courses about this topic.