# ETF: quote tracker

Hi,
is there a way to get a notification from the broker (Interactive Brokers in my case) when an ETF quote loses a specific percentage of its value compared to 1, 10, 60 days before.

I have found some instructions but the reference value is always static, specific to a predefined value.

Perhaps a specific website/tool can do that?

I will use that to increase some of my positions when the market (MSCI index) drops , say for example 10% 15%.

Thanks

You could probably set up a googlefinance formula for that.

Then set up the Google sheet to send you an automated email.

Thatâ€™s all a bit manual to set up, but allows full flexibility compared to the service of a website or app.

4 Likes

I couldnâ€™t ask for a better answer @rolandinho . Beside that google always have some kind of useful services and for free!. They deserve not to pay taxes

Note: there is something wrong with the syntax in the first (google) link. The attributes should be separated by â€ś;â€ť instead of â€ś,â€ť

That depends on your locale, afaik.

2 Likes

I posted something similar here

here is how I did it, for those who wants something similar but have rusty programming skills.

Cell A7 formula looking for a value 2 months old:
The value is displayed in â€śB8â€ť. Note that the values collected during the weekend are shown by googlefinance with N/a .
On the same column the same formula is repeated changing how far in the past I want to check the price.

C8 shows the difference in percentage compared with todayâ€™s value . In case the price is collected during the weekend I had to force the cell to show show â€ś0â€ť instead of an empty one using the IF formula:
=if(B8=0;0;100-(B8*100/\$B\$27))

D8 : threshold check for value in cell C8: if the value exceeds the threshold defined in E8 (-15% in my case), then the cell value will be 1, otherwise 0
=if(C8<=\$E\$8;1;0)

F8: cell used to trigger the email message in case one of the values in column D is 1 (which means one threshold crossed somewhere) . If column D has a cell with one of the value se t to 1 (which means threshold crossed) F8 will be set to 1 as well.
=if(or(D8:D27);1;0)

Finally, the email script will check the value in F8 and send a message if the value is 1

1 Like
By reading and partipating to this forum, you confirm you have read and agree with the disclaimer presented on http://www.mustachianpost.com/
En lisant et participant Ă  ce forum, vous confirmez avoir lu et ĂŞtre d'accord avec l'avis de dĂ©gagement de responsabilitĂ© prĂ©sentĂ© sur http://www.mustachianpost.com/fr/