# Reading Web

**URL:** https://community.glideapps.com/t/reading-web/24148
**Category:** Ask for Help
**Created:** [March 12, 2021, 5:50am UTC](https://community.glideapps.com/t/reading-web/24148 "2021-03-12T05:50:58Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)
#### Post date: [March 12, 2021, 5:50am UTC](https://community.glideapps.com/t/reading-web/24148/1 "2021-03-12T05:50:58Z")

</div>

Hi,

I need Math column to be automatically multiple to a number in Website (forex).  
$1000 x (number)  
which number is in website(4.18).  
Is there any ways to do?

> **[Foreign Exchange Rates (FOREX)](https://www.pbebank.com/Personal-Banking/Rates-Charges/Forex/Foreign-Exchange-Rates-(Forex).aspx)**

\*\*

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/9/39289575dafaf139a8194ded3e515b7b10a36eb5.png) \*\*

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 12, 2021, 6:06am UTC](https://community.glideapps.com/t/reading-web/24148/2 "2021-03-12T06:06:38Z")

</div>

Are you asking how to retrieve the data from the website, or are you asking how to do the calculation?

Are you aware that Google Sheets has a [currency conversion](https://www.howtogeek.com/449986/how-to-convert-currency-in-google-sheets/) function?

---

<div class="post-metadata">

### Author: ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)
#### Post date: [March 12, 2021, 6:11am UTC](https://community.glideapps.com/t/reading-web/24148/3 "2021-03-12T06:11:52Z")

</div>

My question is how to retrieve data from website.  
I just know about the currency conversion in google sheet . But still different from the bank I need.

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 12, 2021, 6:17am UTC](https://community.glideapps.com/t/reading-web/24148/4 "2021-03-12T06:17:24Z")

</div>

You won’t be able to do that with Glide.  
You’ll need to use an external tool or an Apps Script.  
I’d check if the banking site has an official API that can be used, otherwise the next option would be [screen-scraping](https://en.wikipedia.org/wiki/Data_scraping). But if you go down that path, I’d advise checking their terms of use, as scraping could be a violation of those.

---

<div class="post-metadata">

### Author: ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)
#### Post date: [January 17, 2024, 4:53pm UTC](https://community.glideapps.com/t/reading-web/24148/5 "2024-01-17T16:53:03Z")

</div>


