Status Update
Comments
ch...@gmail.com <ch...@gmail.com> #2
Thank you for contacting Google Cloud Platform Support. I understand you are having an issue with internal load balancing and I will do my best to advise you.
Internal load balancers are regional resources, the scope of an internal TCP/UDP load balancer is regional, not global. This means that an internal TCP/UDP load balancer cannot span multiple regions. Within a single region, the load balancer services all zones. [1]
A feature request exists to enable an internal load balancer which can handle requests from multiple regions[2]. But I can neither provide you with an ETA for its implementation, nor a guarantee that it will ever be supported. If you would like to create your own feature request, follow the link to Google issue tracker to search or create feature request [3].
Your VMs are able to talk to each other from one region to another as they are connected through the same VPC. Resources within a VPC network can communicate with one another using internal (private) IPv4 addresses, subject to applicable network firewall rules.[4] However, for ILB the behaviour is handled differently due to the regional nature of the ILB(s).
The reason VM instances attached to a network with a specific address mask getting assigned IP with /32 mask is a design requirement of GCP. However, let me explain why VM instances are assigned with the /32 mask on Google Compute Engine (GCE). Please note that the /32 is an artificial construct. The instance talks to the software defined network, which creates and manages the "real" subnets. So, it is really a link between the single address and the gateway for the subnet. As long as the link layer is there, communication is established, and everything works.
In addition to that, network masks are enforced at the network layer, not the host layer. This helps avoid generation of unnecessary broadcast traffic (which underlying network wouldn't distribute anyway), this might further clarify why VM instances are assigned with a /32 netmask, when they are attached to a subnet, for example, /24 mask.
I hope that makes things clearer for you. If you have any other questions or concerns about your issue, please do not hesitate to contact me by replying to this message. I will be more than happy to help at that time.
[1]ILB Scope:
[2]Feature Request for multi-region ILB:
[3]Create and Search feature requests:
[4]VPC Specifications:
ro...@gmail.com <ro...@gmail.com> #3
I hope that this feature request
I am surprised that it has been designed like this because it's a pretty big drawbacks compared to AWS for example.
Do you know if there is another solution for me to interconnect local service to another region except create loadbalancer in a dedicated instance ?
Thanks in advance,
Kévin
qm...@gmail.com <qm...@gmail.com> #4
jb...@gmail.com <jb...@gmail.com> #5
wa...@gmail.com <wa...@gmail.com> #6
You'll be pleased to note that GKE 1.16 allows you to annotate a service of type LoadBalancer such that it is both internal and globally accessible. We can close out this issue now.
jp...@google.com <jp...@google.com> #7
Thanks for reporting, I have triaged to the appropriate team to address this and shared many of the broken symbols to investigate.
ma...@gmail.com <ma...@gmail.com> #8
jp...@google.com <jp...@google.com> #9
Some of the Market:Symbol
pairs should be working again such as NYSE:PFLT
and NYSE:HMC
. For others such as FRA:*
, the returned value is still incorrect. Future updates will be posted here. Thank you for your patience.
jp...@google.com <jp...@google.com>
ja...@googlemail.com <ja...@googlemail.com> #10
ag...@gmail.com <ag...@gmail.com> #11
rg...@pasareladirecta.com <rg...@pasareladirecta.com> #12
thanks
mi...@gmail.com <mi...@gmail.com> #13
Even worse, all my ETF in Portfolio now disappeared completely.
Please fix it soon.
thx.
an...@gmail.com <an...@gmail.com> #14
wh...@gmail.com <wh...@gmail.com> #15
ma...@gmail.com <ma...@gmail.com> #16
to...@gmail.com <to...@gmail.com> #17
an...@zietara.com.au <an...@zietara.com.au> #18
sg...@gmail.com <sg...@gmail.com> #19
sz...@gmail.com <sz...@gmail.com> #20
ma...@gmail.com <ma...@gmail.com> #21
to...@gmail.com <to...@gmail.com> #22
go...@gmail.com <go...@gmail.com> #23
below ones are still not working :
IST:AKYHO
IST:AZTEK
IST:CRDFA
IST:MAKTK
IST:PENTA
IST:SDTTR
ew...@gmail.com <ew...@gmail.com> #24
[Deleted User] <[Deleted User]> #25
ti...@gmail.com <ti...@gmail.com> #26
FRA:2B7K
FRA:AYEM
FRA:AYEW
FRA:XRS2
FRA:LYP6
FRA:LYQ7
ma...@gmail.com <ma...@gmail.com> #27
pv...@gmail.com <pv...@gmail.com> #28
pv...@gmail.com <pv...@gmail.com> #29
From
on 26-7-2023: issue 76403135
Thank you Patrick! Problem with Financial times values is that they come as text and not as a number. I have not figured out how to convert these text values to numbers so that I can do some simple maths... Any help with that?
Have tried Value -> format -> Number with no luck.
To convert text to number you can use either =VALUE or =ABS but you need to use 2 cells, the first cell has the text and the second cell will have the number (in my example I'm using =ABS). Below is a tutorial how to convert text to number.
fr...@gmail.com <fr...@gmail.com> #30
Thanks very much for that although I fail to believe anything is being "tracked" at all, at least not by Google.
So, once more my two cents in this matter. Since about a month all tickers that are registered on the XETRA (Frankfurt Exchange) are not working in Google Finance. They have disappeared.
Examples:
FRA:NUKL
FRA:SXRJ
FRA:WTi2
FRA:IQQQ
And many more.
ke...@gmail.com <ke...@gmail.com> #31
TSE BIP.UN
TSE BEP.UN
TSE BEP.UN
TSE BIP.UN
TSE AP.UN
Broken for several months.
no...@gmail.com <no...@gmail.com> #32
to...@gmail.com <to...@gmail.com> #33
mr...@gmail.com <mr...@gmail.com> #34
ho...@gmail.com <ho...@gmail.com> #35
SPDR S&P Euro Dividend Aristocrats ETF FRA:SPYW
SPDR S&P US Dividend Aristocrats ETF FRA:SPYD
ma...@gmail.com <ma...@gmail.com> #36
SXR8 on the german XTRA exchange
Also N/A both on website and google sheets.
en...@gmail.com <en...@gmail.com> #37
th...@gmail.com <th...@gmail.com> #38
Ticker: IUSQ
ti...@gmail.com <ti...@gmail.com> #39
he...@gmail.com <he...@gmail.com> #40
Also N/A on website Google Finance
on...@gmail.com <on...@gmail.com> #41
vo...@gmail.com <vo...@gmail.com> #42
wo...@gmail.com <wo...@gmail.com> #43
ok...@gmail.com <ok...@gmail.com> #44
TSE:CAR.UN
TSE:IIP.UN
TSE:BEP.UN
I mean... Stock market transactions take place in milliseconds, those days.
MONTHS!?
Google?! Hellooooooooooooooo!!
fr...@gmail.com <fr...@gmail.com> #45
th...@googlemail.com <th...@googlemail.com> #46
fr...@gmail.com <fr...@gmail.com> #47
Then there is this :
Here it is possible to create and escalate cases but it looks like that is for Cloud services
ca...@gmail.com <ca...@gmail.com> #48
em...@gmail.com <em...@gmail.com> #49
jp...@google.com <jp...@google.com> #50
As this is the issue tracker for the Google Sheets API, please submit feedback for Google Finance,
Description
The Google Finance to report data issues.
=GOOGLEFINANCE()
formula depends on the underlying data of Google Finance and its API. Please use the "Send Feedback" button inPlease verify your ticker symbol:
https://www.google.com/finance/quote/[EXCHANGE]:[TICKER]
If Google Finance has the correct data, but
=GOOGLEFINANCE()
formula is failing, please send feedback directly within the Google Sheets Application menu.Help > Report a problem
This issue tracker is for developers using the Sheets API as defined athttps://developers.google.com/sheets/api/guides/concepts .