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.

https://support.google.com/docs/answer/3093281?hl=en&visit_id=637559285317217528-1692688140&rd=1

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 :slight_smile: @rolandinho . Beside that google always have some kind of useful services and for free!. They deserve not to pay taxes :stuck_out_tongue:

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:
=GOOGLEFINANCE(“AMS:IWDA”;“high”;TODAY()-60;TODAY()-59)
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/