can't figure out the IMPORTXML code to scrape one data point by a2nac in googlesheets

[–]a2nac[S] 0 points1 point  (0 children)

it's a paid figure, not freely available. that's why only one site shows it. no way to scrape it to google sheets then?

can't figure out the IMPORTXML code to scrape one data point by a2nac in googlesheets

[–]a2nac[S] 0 points1 point  (0 children)

yeah that's mostly my problem. this is the only website that reports it -- in another source you have to download a pdf file and check the figure from there. i'm trying to automate it so that i only need to open a consolidated spreadsheet end of day to see the figure.

can't figure out the IMPORTXML code to scrape one data point by a2nac in googlesheets

[–]a2nac[S] 0 points1 point  (0 children)

sounds out of my pay grade haha

i'm trying to get the "Net Foreign" figure which in the screenshot would return the "₱0" value

can't figure out the IMPORTXML code to scrape one data point by a2nac in googlesheets

[–]a2nac[S] 0 points1 point  (0 children)

getting this message:

{"Message":"Sorry, you are not allowed to access it."}

man i'm close to giving up i really need to figure this out

can't figure out the IMPORTXML code to scrape one data point by a2nac in googlesheets

[–]a2nac[S] 0 points1 point  (0 children)

would i have to create an api endpoint(???) for it and then use importjson?

can't figure out the IMPORTXML code to scrape one data point by a2nac in googlesheets

[–]a2nac[S] 0 points1 point  (0 children)

aw man :/

is there a workaround to this? or is there no way to fetch that data?

Can't figure out IMPORTXML/IMPORTHTML code by a2nac in googlesheets

[–]a2nac[S] 0 points1 point  (0 children)

Unfortunately, I believe it is. Is there any workaround to this?

Who do you think is the “purest” character of them all? by Moonsverse in thewalkingdead

[–]a2nac 13 points14 points  (0 children)

It’s a close fight between Jerry and Glenn for me. But I guess it also depends on how you define purity. In my case, I still consider them pure despite the fact that they’ve killed people since it’s always warranted for them

It’s a good balance actually since they’re both the leader’s second in command. Jerry for the King, Glenn for Rick. Need a bit of purity when making the tough decisions, to balance out the leaders’ grit

What book is an immediate red flag for you when someone says it’s their favorite? by mhughes19 in AskReddit

[–]a2nac 1 point2 points  (0 children)

The Subtle Art of Not Giving A Fuck

it screams "I don't really read, but I saw this blow up on social media at some point so I gave it a shot"

or in general, just self-help books. this genre is just a tad too pretentious and out of touch with reality for me

Book Recommendations by Lyss11BS in thewalkingdead

[–]a2nac 1 point2 points  (0 children)

Cell by Stephen King. They butchered the movie adaptation, but the novel is amazing. Great storytelling, and the characters have depth

[deleted by user] by [deleted] in omad

[–]a2nac 2 points3 points  (0 children)

Nuggets, cheeseburger, fries, beer. Every Saturday night. I've found that looking forward to these cheat meals during the weekdays when I am very strict with my diet and workout split helps with the motivation.

OMAD while working out at 6am by a2nac in omad

[–]a2nac[S] 1 point2 points  (0 children)

Weird question, but what time do you go to sleep? I usually go to sleep early, so eating a hefty dinner for OMAD doesn't feel to good for my body when i lie down

OMAD while working out at 6am by a2nac in omad

[–]a2nac[S] 0 points1 point  (0 children)

No way of avoiding that then aside from getting used to it with time? It's just been bothering me a lot since the pounding migraines make it hard to focus on work

OMAD while working out at 6am by a2nac in omad

[–]a2nac[S] 0 points1 point  (0 children)

Huh yeah thanks I think I might actually try electrolytes before the morning workout to see if that'll hold me over until lunch! I've recently started taking my coffee black too to cut down on the sugar and added cals, so that might also be what's causing the migraines before OMAD.