0

I want to get the dividend of companies like ENG.MC or other stock like GSY.TO, but Sheets did not find the dividend.

i put on my Google Sheet: =IMPORTXML($D$25;D24)

I want the "Forward Dividend & Yield" from Yahoo but i recieved a #N/A example of the error

Toni
  • 1
  • 1
  • I apologize for my poor English skill. Unfortunately, I cannot understand your expected value. Can I ask you about the detail of your expected value? – Tanaike Jan 31 '23 at 01:58
  • i uploaded a picture in the pos to show the error – Toni Feb 01 '23 at 14:31
  • Thank you for replying. From your reply, I think that in this case, the reason for your current issue is due to the data in the HTML is being encrypted by AES. But, fortunately, as the current sample script, I have posted it to [this thead](https://stackoverflow.com/q/75250562). I think that this will be useful for retrieving your expected values. Please check it. But, it seems that the server-side often changed the specification of encryption. So, at that time, it is required to think of a new solution. Please be careful about this. – Tanaike Feb 02 '23 at 01:27

0 Answers0