Recent content by cpampas

Gasman, I am going to review the calculation in my code again Maybe you get -1, because you are not entering into the inputbox any share ticker Did you try to enter MMM ?

Thanks for your reply Plog. I did as you said, and confirm that 2 different websites, yahoo finance and morningstar , have very similar RSI values (65) as an example for 3M (share symbol MMM) my function that i already changed so many times, keeps on returning completely diferent values. I...

I am trying to calculate the RSI(Relative Strenght Indicator), for a stock at the current day but with the function i am using , there is a huge difference between the result and published RSI data like yahoo finance I also tought of downloading RSI data , instead of calculating, i just cant...

Arnel, That works pretty well, until now with no issues Many Thanks

Gasman, Interesting the www.alphavantage.co API, it might be the solution for me, in the meantime ArnelGP, yes the search string is not working with the symbol i mentioned, I think BA would work https://www.google.com/finance/quote/BA:NYSE if i use MSXML2.ServerXMLHTTP i can avoid the error...

dim url As String Dim xmlhttp As Object Dim st As Integer Dim Content As String Dim searchString As String Dim position As Long, exchange as string url="MMM" exchange="NYSE" url = "https://www.google.com/finance/quote/" & UCase(symbol) & ":" & exchange Set xmlhttp =...

Thank you all for you kind help I followed Mark's idea . genious ! It works like a charm

I ve been trying this for hours with no results, I wonder if someone can give me a hand. Ihave a string: str=" On Monday, 13th Nov 2023, Baxter International Inc stock price gained 2.71%, going from $32.82 to $33.71. Volume increased on the last day and 5 million more shares were traded than the...

the idMov gotfocus event will notwork for me since records are not being populated manualy. I ended up updating the field txtPrevious, on opening the form, and after that a conditional format of the textbox that looks like a line Thanks for your help Private Sub Form_Open(Cancel As Integer)...

ArnelGH , in the details paint event i cannot set the value of the textbox Cj_London, the approach of mimic a line with a textbox is great, but i still dont know what event i put txtCurrent =idMov

In a continous form is it posible to make visible a line, everytime IDMov changes ? something like this, but I am not clear on what event of the form, where the code would be triggered If Nz(Me.txtPreviousid, "") = Me.idMov Then Me.Line5.Visible = False Else Me.Line5.Visible...

Attached rules of conditional formatting, and result with delay and without delay this is the syntax of the query qryMatchPosibleSCNB_P , the other one is similar: UPDATE tblSBNC_P SET tblSBNC_P.cor = 7000 WHERE (((tblSBNC_P.valor) In (SELECT qryMatchPosible.valor FROM qryMatchPosible ))...

the database is not splitted, would that increase performance ? I am doing an accounting bank reconciliation of data, so the records where bcor=7000 have a debt sum equal to a credit value in another table Typically i would have between 60 to 150 records in this table, and one record in the...

the conditional format rule is : [bcor]=7000, wich is a text field, if true it sets the color of another text box in the table to a yellow color bcor is bound to an indexed field How would rich text increase speed ? i suspect thaat this is so slow because I have a continous form, and the format...

One Requery only wont work form me, because in between requeries the user edits data based in the control colors.