Home Creators Posts Import Register Favorites Logout

Videos

  • 400566189.mp4

Downloads

Content

The training we have for this week that I have shared with you was about the AI Stock Analyzer. If you have not seen it yet, you can view it right here on YouTube.

Now that the training has been released, I am looking for your feedback to make this even better, just for you, our incredible Patreon Members.

So, what Feature can I add for you? Did you find an issue you want me to fix? Or is there a particular area you would like me to focus on?

Please comment your ideas and feedback to any  of these below and I will do my best to not only create an updated workbook but release a private training video next Monday, right here on Patreon.

Files

Comments

jwuj97f

This is an interesting tool; however, I am getting mixed results i.e. 1. yesterday I could "add new stock" (not today - getting message 'Ticker symbol for SHRAX not found. Please reenter the ticker symbol'); 2. the "Update Recomm." button has never worked for me ( I am connected to the internet, my API keys are valid) yet I get error message "Your question was not sent. Please check your internet connection and OpenAI API Key" Note: i am giddy with joy - while using the other functionality (very nice tool)

Excel For Freelancers

Have you removed this ticker symbol and tested it with others. is this the only one you are having trouble with? I believe this ticker is a fund? Not a company?

jwuj97f

i have tried 13 ticker symbols (none are working today) If I try to renter a ticker symbol created yesterday - the message is correct the ticker symbol already exist. I can not add any new symbols. deleting a ticker symbol seems to be working.

Excel For Freelancers

Hi and thanks try adding major stock symbols, and if it does not work, please check the http response in order to determine the cause.

jwuj97f

I get the same with ticker JNJ (Johnson & Johnson NYSE);

Excel For Freelancers

I did not receive the error so you would have to go and check the response string in the immediate window (I show you how to do this in the training video) I hope this helps and thanks so much.

Alberto Rosales

I have an error in Microsoft Visual Basic, the error is the '3002' in time ejecution, when I debug the code it shows the "HistData_Macros in the line 228 which is FileStream.LoadFromFile FilePath & ".txt", how can a fix it?, the files are in the folder but the program does not read the files.

Excel For Freelancers

HI Alberto, can you hover over the 'FilePath'? Also try removing the "& ".txt" as it may not be needed Let me know if this works

Alberto Rosales

I have now other problem, today I receive this message "Your question was not sent. Please check your internet connection", I have the Polygone and the OpenAI Key's, but suddendly this problem is new for me, before the file worked fine.

Excel For Freelancers

Hello Alberto, thanks for your message. I also had a problem the OpenAI API on all of my attempts to run a request to their server. It was very frustrating, however, this morning the issue seems to be fixed on their end. Can you try again and let me know? (Polygon was not an issue but OpenAI has some sort of an issue for a few hours yesterday)

Alberto Rosales

Greetings, today I have the same problem, perhaps some firewall, antivirus or something?

Excel For Freelancers

Hi Alberto, please debug the response and see what is being returned by the OpenAI API, this will help determine the cause. (I am not having the problem that I had the other day, so for me its working) I hope this helps and thanks so much.

Mark Knutson

I'm getting an error '3002' in the sub UploadDataToVectorStore. The line FileStream.LoadfromFile Filepath is highlighted. It is creating the store but it is an empty file. When I hit the update recomm. button it comes up unknown. Any ideas what I'm doing wrong?

Mark Knutson

In the end of your original video on the ai stock analyzer it errors out on you and you add a ".txt" to the file name. But in the updated patreon member's file the ".txt" is not in the path name. Should it have the ".txt" on the path name? I added it but it still errors out on the stock price data upload. Believe it or not the chatgpt recommendation is working even with no price data uploaded to openai's website. Have you made any changes to the patreon members update since you originally posted it? Thanks for your help. Mark

Excel For Freelancers

Hi Mark, thanks for your message. This is easy to check. When there is a bug, just open the immediate windows and type something like ?FilePath Then you can view the actual file path and see if is correct. IF not, you can then make any necessary changes. I have not made changes to the updated Patreon version since posting. I hope this helps and thanks so much.