friday | Want to stretch your brain and practice some dark

I am not aware of a way for GOOGLEFINANCE to automatically adjust for no trading days.

One way to do it is to get the "price" data for the last 7 days (to be safe) and then query that data to get the "price" value next to the max date.

This formula works for me: =INDEX(QUERY(GOOGLEFINANCE("NASDAQ:MSFT","price", TODAY()-7, TODAY()),"select Col1, Col2 order by Col2 desc",1), 2, 2)

Look at this measure:

An elegant solution is to update node attributes in networkx rather than the output dict. Use nx.set_node_attributes:

Consider, if your spreadsheet was like this - parsing each row (and ignoring headers) would allow you to generate the desired output with greater ease:

You can transpose the sheet_to_json output to achieve this. Refer to this issue. Note sheet_to_json is called with {header: 1}:

Try this

You already have your JSON data in a string, so you need to parse it into a JavaScript object (an array in your case):

The fseek is probably wrong. SEEK_CUR is relative but we need to give it a negative offset to seek backwards to the previous/just read position.

Never use gets. The man page says why. But, see also: Why is the gets function so dangerous that it should not be used?

Doing fflush on an input stream is bad juju. It should only be used for output streams. And, with gets is probably unnecessary.

Don't intermix scanf and gets/fgets/fgetc. This just leads to problems.

Rewrite using fgets. You can put that in a common function to avoid replicating code.

Side note: You probably do not want to be calling medicine from within editmed. I assume medicine is the main menu and one of the entries in the menu is to call editmed. Better that the caller of editmed does this [based on a return code from editmed]. Otherwise, you could end up with arbitrary/infinite recursion.

Here's a refactored version that should work better.

It is a simplified version from my answer: Cannot implement Linked List in the given code

I've compiled it but not tested it:

You need to fetch the data from the year variable twice, year @ 100 .... I think after that ?adaptday will work. There is forth word within \ n lo hi -- flag ; flag is True if lo <= n < hi for checking numbers within ranges,

In Forth it's unusual to use so many variables. The values are normally stored on the stack. j as a variable could override the j used as the outer do loop counter. I've seen k used for the next outer loop too!!

I'd implement it something like this. I can then run the words in the console with stack input to see what is happening to help debug.